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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

error in exp

Hi all,

currently my variable value is 

vCurrentWeekk=Week(today())

so in  expression I used    :  =Count({<WeekNumber={$(=vThisWeek)}>}id)     this will only only  this week data if I select other week in  filter it is not reflecting   so I tried below expression but its giving error

=if(GetSelectedCount()=0,week(today(),max(WeekNumber)))

13 Replies
Kushal_Chawda

Have you tried above?

soniasweety
Master
Master
Author

yes kush,

I just missed to pass the filed inside the get function,its working now.

Anil_Babu_Samineni

You could use this too?

=if(GetFieldSelections(WeekNumber)=0,week(today()),max(WeekNumber))


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
soniasweety
Master
Master
Author

yes used the same