Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Set Analysis revenue smaller than XYZ date, which still reacts to a selection


I am trying to show all revenue, which was before or in 201702.

In my use case, there is in 201701: 10$, 201702: 20$ and 201703: 50$.


Now my table shows me 30$  revenue (which is correct for 201701+201702).

But I would like to be able to select kickIN =201701 in the list box, and the graph should show me the subtotal of 201701 (because it is still between my set analysis border).

Unfortunately it is fixed and does not show any difference when I select something. Does anybody have an idea for me please?

1 Reply
Not applicable


sum({$<Validity={'Longtime'},kickIN *={"<=201702"}>}revenue)

for intersection...