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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

exclude previous value

all,

i am struggeling with the following task:

in a bar chart i am counting distinct users per month. The number of months used as dimensions is determined by an input field that limits the number of months in the chart to either current month - inputfield value or max selected month - inputfield value if one or more months are selected. this all works OK.

the thing i cant get to work is: i want to

a) have a simple count on distinct users for the first month listed in the chart

b) count only those users not counted in the first month in the second month + all users from first month

c) count only those users not counted in b) + all users from third month

[...]

i have attached a little example (w/o the input field piece). I would expect the values for the three months to be as follows:

Jan: 4

Feb: 6

Mar: 8

Thanks for some help!

0 Replies