topic Re: Need an expression for selection based on users filters applied in QlikView

Need an expression for selection based on users filters applied

keerthana96 — Sun, 19 Jan 2020 11:06:12 GMT

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.

Taoufiq_Zarra — Sun, 19 Jan 2020 11:59:16 GMT

can you share a sample data and develop your need

keerthana96 — Sun, 19 Jan 2020 13:55:42 GMT

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

Taoufiq_Zarra — Sun, 19 Jan 2020 18:28:55 GMT

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