Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Need Help

Hi Community,

I have 2 issues, please can anyone help me...

1.  I want to show Maximum of the record for based on particular ID

suppose  i have ID=100, i want to written Maximum date record... (3rd record)

                                  




2. Suppose i have create startdate and enddate calendar.

i am select startdate:  02/10/2013

                 EndDate:  02/25/2013

Here i want to written 02/10/2013 --->  ID wise i want to written Max of Date value

                                 02/11/2013--> ID wise i want to written Max of Date value

                                  and so on

                                02/25/2013--> ID wise i want to written Max of Date value

and i want calculate FTD, WTD and MTD.

PFA,

12 Replies
paulwalker
Creator III
Creator III
Author

HI Macro,

In my particular case,

start date:  2013/01/01              EndDate:  2013/02/21

ID=101 record it should be Arrow mark record (value should should be 23).... based on select range date..

Capture.PNG

Hope you understand.............

paulwalker
Creator III
Creator III
Author

please anyone can help me....

Not applicable

ya u have to take maximum id