Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have read lots of discussions about limiting dimension in pivot table, anyhow I need to ask:
How can I limit dimension in pivot table to show expressions just for latest 10 dates?
Thank for your valuable help!
the pity is that I'm not allowed to do any database changes or enhacements. I need to do this pure in qlik.
so again: how to limit dimention of pivot table to show only 10 latest dates from a field that can contain any (discontinuing) date values?
Check enclosed file....
No in qlikview script load i am suggesting.
not true
Check file I have enclosed..
yeah, its doing its job, but date values becomes corrupted like :
41737.378923611 |
41738.0865625 |
41738.314502315 |
41738.333645833 |
instead of original:
8.4.2014 8:00 |
8.4.2014 9:05 |
9.4.2014 2:04 |
9.4.2014 7:32 |
9.4.2014 8:00 |
9.4.2014 14:55 |
thank you!
Try below in Script..
=Date(Date#(YourDateField,'D.M.YYYY h:mm')) as YourDateField
or
Date(YourDateField)
or
Date(FLOOR(Date#(YourDateField,'D/M/YYYY h:mm'))) as YourDateField
okey, now I see that dates are not ordered and are not the latest ones... originally I asked for 10 latest dates from field.
Please check enclosed file..
Thanks for your effort, Manish!
Please, can you explain a bit what is causing ordering here?
in addition, what is the difference between Date() and Date#() functions?
Thank you!