Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator II
Creator II

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

Hello,

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$.

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

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
Anonymous
Not applicable

try:

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


for intersection...