Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
please find attached
Daniel,
Thanks for your time
but I need to show only max(date) values. I don't want all the dates
Try to remove the Start field from the Dimensions...please find attached
Daniel,
Kindly find the attachment
I need the values for that date
Please find attached
I used the Date again as dimension but with the following expression:
if(Start=max(total Start),Start)
Daniel,
Could you provide the sample app
I could not able to fix it from my end
its attached in the above posting