Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
keerthana96
Contributor
Contributor

Need an expression for selection based on users filters applied

I am using a dataset to analyze and visualize the data using QlikView.  My query is I need an expression for the below eg:

scenario 1: The day contains -3,-2,-1,1,2,3,4 and the user selects '1' the count of the activity should the status minimum of day 1.

 

 expression 1:  =Count({<Acitivity={'XXXx'}>}Activity)

 

scenario 2: if the user selects the day as '1', then the count of the activity should be shown for the current day.

 

experssion2:   =Count({<ACTIVITY={'XXXX'},Min([Days])>}ACITIVITY)

 

 

Please help me out.

 

3 Replies
Taoufiq_Zarra

can you share a sample data and develop your need

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
keerthana96
Contributor
Contributor
Author

could you please help me with this sample scenario which I mentioned in the post. If not kindly use this data

Taoufiq_Zarra

on this sent corpus, can you add more details about the need

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉