Top(Max value) discarding others

[Anonymous]

Hi,

I am attaching the sample app and go through it to find top(Max) values and discarding others in a pivot table

thanks in advance

[danieloberbilli]

QlikView does not identify your field as timestamp.

Try to edit your timestamp format like that - then you can use max() functions in your chart table

[danieloberbilli]

please find attached

[Anonymous]

Daniel,

Thanks for your time

but I need to show only max(date) values. I don't want all the dates

[danieloberbilli]

Try to remove the Start field from the Dimensions...please find attached

[Anonymous]

Daniel,

Kindly find the attachment

I need the values for that date

[danieloberbilli]

Please find attached

[danieloberbilli]

I used the Date again as dimension but with the following expression:

if(Start=max(total Start),Start)

[Anonymous]

Daniel,

Could you provide the sample app

I could not able to fix it from my end

[danieloberbilli]

its attached in the above posting