topic Re: List box elements and YTD in QlikView

List box elements and YTD

Fri, 24 Oct 2014 11:40:22 GMT

Hi,

I have a sheet with year filter and month filter.

I'm creating a list box with products sold.

In the expression of the list box I added the sold value YTD (from January to the filtered month of the filtered year).

The values are correct.

Product 3 has been sold in March but not in April, so when I select April it is grey in the filter, even if value YTD is not 0.

How can I get it available even when I select April?

The image above is only an example created in Excel to display the behaviour of the list box.

Thank you in advance for the help!

Giada

Re: List box elements and YTD

Gysbert_Wassenaar — Fri, 24 Oct 2014 11:50:32 GMT

Add {1} to your expression. So for example sum(YTD) would become sum({1}YTD).

Re: List box elements and YTD

Fri, 24 Oct 2014 12:55:46 GMT

Thank you for the reply, but I don't have directly YTD value.

I get it as months sum through set analysis:

sum({$< id_Month={"<=$(#=Only(id_Month))"}, ...>} MonthlyValue)

Re: List box elements and YTD

Gysbert_Wassenaar — Fri, 24 Oct 2014 13:22:26 GMT

Please find a dictionary and look up the meaning of the word 'example'

Re: List box elements and YTD

Fri, 24 Oct 2014 13:41:09 GMT

Thank you again for the advice to look up the meaning of "example".

Now that i now the meaning I can say that your example doesn't work for me.

I tried:

sum({1}{$<.............

sum({1<..............

sum({$1<.........

sum({$_1<................

Re: List box elements and YTD

Gysbert_Wassenaar — Fri, 24 Oct 2014 13:56:44 GMT

My apologies for not reading your first post good enough.

If I understand you correctly what you want is not possible. An excluded value cannot be a possible value at the same time. If Product3 is sold in March, but not in April then Product3 will never be a possible value if you select April. The selection of April contradicts Product3. No amount of set analysis will change that. The only way to make Product3 a possible value when you select April is to add a record to your source data in the script that adds Product3 with a sales amount of 0 for April.