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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

How to separate data into happened , On the day and Upcoming and then finding Top performer each day ?

Hi All ,

How to separate data into happened(past) , On the day(current) and Upcoming(future) programs  and then finding Top performer each day ?

Please find attached data for the reference .

Thanks & Regrds

Shekar

14 Replies
YoussefBelloum
Champion
Champion

like this ?

pivot_screen.png

shekhar_analyti
Specialist
Specialist
Author

Actually Not like that but

p2222.png+++

shekhar_analyti
Specialist
Specialist
Author

Note: I n above screenshot , i have removed top performer part of req

YoussefBelloum
Champion
Champion

Sorry I'm stuck, I don't know if it possible to have different level of detail on each month..

and if it possible I've never done it before.

Good luck with this

shekhar_analyti
Specialist
Specialist
Author

Thanks you , No Issues . Cheers !!