topic Re: Table Condition with selected filter in QlikView

Table Condition with selected filter

pietapa — Tue, 03 Jan 2023 10:16:34 GMT

Hello guys,
I have a question. How I have to define the condition to my table so that I get zeros for all entries for a special filter? My table looks like below.

I tried this to see what happend:
If(Filter1="S",0,1)
But when I select the S at Filter1 I get an error message : Condition for calculation not fulfilled.

My problem is that I have no data for this filter until Dec22. Therefore I wanted to show zeros all of my entries.
Thank you for help

Re: Table Condition with selected filter

Mark_Little — Tue, 03 Jan 2023 10:33:19 GMT

Hi,

I do not fully understand your use case, so may not be the right solution.

But if you are trying to evalute something being selected you want to use the GetFieldSelections() function

Something like

If(GetFieldSelections(Filter1)="S",0,1)

Re: Table Condition with selected filter

pietapa — Tue, 03 Jan 2023 11:15:02 GMT

Hi @Mark_Little
okay I try to explain it more understandable.
My original data looks like that

I have a region, date, Filter1, Filter2 and the count of this kinds. And If you can see if Filter1 is L or S there are no values for these months. To get an better overview I created a cross-table like above, where you have the count of every region for each month. Now what I would like to have is if I select Filter1=S, my cross table should show me for every cell 0 beside Dec-22.

I tried your suggestion but it does not work 😞