Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sumitsahu009
Not applicable

Measuring on calculated measure by a dimension (QlikSense)

Hi,

I have a usecase, where i want date as filter, count(transaction_id) as filter and count(distinct user_id) as a measure.

So basically, when i filter date, "number of transactions" done by users should be calculated in the dimension filter,  which i can select and see count of users who have done that particular "number of transactions" selected. I cannot keep transaction count as a dimension because it will be calculated for some fixed timeframe but i want it for the date filtered.

I am not sure how I can implement this with QlikSense. Would really appreciate if someone can help me on this.

Please find below the table for reference.


Question which it should be able to answer:

-> If I select date 2 to 8 and number of transaction =2, the answer should be 2 because a and d have done 2 transactions between date =2 and date= 8

 

table_idtransaction_iduser_iddate
11a1
22a2
33a3
44s4
55s5
66s6
77d7
88d8
99e9
1010e10
1111e11

Thanks