I have a chart with a calculated date dimension. One of the issues I had in the past with original versions PowerPivot was that there was only 1 possible sort order based on display.
So what happens when Apr comes before Jan in a textual sort in Qlikview?
This calculated dimension expression takes advantage of the dual function to represent dates as numeric for sorting purposes:
=dual(month(MaturityDate) & '-' & Year(MaturityDate),Num(year(MaturityDate),'0000') & num(Month(MaturityDate),'00'))
By sorting numeric, this expression will show the proper sort order for dates.
Helping threads here.
https://community.qlik.com/blogs/qlikviewdesignblog/2014/07/18/dual-exists-useful-functions
https://community.qlik.com/thread/58791
I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting Qlikview Online Training Hyderabad
ReplyDeleteFon Perde Modelleri
ReplyDeletesms onay
VODAFONE MOBİL ÖDEME BOZDURMA
NFTNASİLALİNİR.COM
Ankara evden eve nakliyat
TRAFİK SİGORTASI
dedektör
kurma.website
aşk kitapları
ümraniye alarko carrier klima servisi
ReplyDeleteçekmeköy lg klima servisi
ataşehir lg klima servisi
çekmeköy alarko carrier klima servisi
ataşehir alarko carrier klima servisi
tuzla beko klima servisi
tuzla mitsubishi klima servisi
çekmeköy vestel klima servisi
ataşehir vestel klima servisi