Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Top(Max value) discarding others

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

12 Replies
Highlighted
Specialist II
Specialist II

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

Capture11.PNG.png

Highlighted
Specialist II
Specialist II

please find attached

Highlighted
Contributor III
Contributor III

Daniel,

Thanks for your time

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Contributor III
Contributor III

Daniel,

Kindly find the attachment

I need the values for that date

Highlighted
Specialist II
Specialist II

Please find attached

Highlighted
Specialist II
Specialist II

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

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

Highlighted
Contributor III
Contributor III

Daniel,

Could you provide the sample app

I could not able to fix it from my end

Highlighted
Specialist II
Specialist II

its attached in the above posting