Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chriys1337
Contributor

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
roharoha
Valued Contributor III

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

try:

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


for intersection...

Community Browser