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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II
‎2020-05-24 05:41 AM

issue in set analysis

Hello Everyone,

I have a scenario wherein, user is filling his details every week. `Let say a user has filled details in Week1, Week2 and Week3. Now if anyone selects Week1, Week2, Week3 then latest week data should be visible i.e Week3. IF user selects Week1, Week2 then again latest week data i.e. week2 data should be selected. It can be the case that User 1 has filled data till week3 and user2 has filled data till week2 and if the selection of Weeks are Week1, Week2, Week3 then for User1, Week3 data should be reflected and for User2 Week2 data should be reflected. Can anyone help em how to achieve this? For your reference attached are the files.

Labels (1)
Labels
Book1.xlsx
Dummy.qvw
1,092 Views
0 Likes
1 Reply
rubenmarin
MVP
MVP
‎2020-05-25 07:47 AM

Hi, If last data is fixed (not depending of selections) the better option I think is to set a flag in script to the last record of each user.

Or you can try using FirstsortedValue, like: FirstSortedValue(FieldToShow, -Week)

1,027 Views