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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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") 😉