Limit Dimension in pivot table for date

[#1]

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!

[#2]

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?

[MK_QSL]

Check enclosed file....

[its_anandrjs]

No in qlikview script load i am suggesting.

[#5]

not true

[MK_QSL]

Check file I have enclosed..

[#7]

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!

[MK_QSL]

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

[#9]

okey, now I see that dates are not ordered and are not the latest ones... originally I asked for 10 latest dates from field.

[MK_QSL]

Please check enclosed file..

[#11]

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!