topic conditional display column in straight table. in QlikView

conditional display column in straight table.

ronaldwang — Wed, 25 Nov 2020 16:16:04 GMT

I have a table where I show the sum of sales of each month using formula like sum({<month={Oct},year={2017}>}amount) as Oct17 Sale, sum({<month={Nov},year={2017}>}amount) as Nov17 Sale. In the condition column how do I set the condition so that Oct17 Sale will be displayed only when Oct & 2017 is selected? thanks

Re: conditional display column in straight table.

Anil_Babu_Samineni — Wed, 13 Dec 2017 05:58:31 GMT

If you make condition like Sum(amount) and list boxes are Month & Year (Go ahead and filter) on Oct & 2017. What are you getting?

Re: conditional display column in straight table.

prma7799 — Wed, 13 Dec 2017 06:01:30 GMT

simply write if(((MonthName ='Oct')),1,0) in Condition box

Re: conditional display column in straight table.

ronaldwang — Wed, 13 Dec 2017 06:05:11 GMT

it will still display

Re: conditional display column in straight table.

ronaldwang — Wed, 13 Dec 2017 06:05:45 GMT

but user can select Oct,Nov, Dec etc, then the month name will not be uique

Re: conditional display column in straight table.

prma7799 — Wed, 13 Dec 2017 06:08:07 GMT

How many expressions do you have in your chart?

Re: conditional display column in straight table.

Anil_Babu_Samineni — Wed, 13 Dec 2017 06:09:23 GMT

does it mean, You can set it up as below

If(GetFieldSelections(Month) > 0 and GetFieldSelections(Year) > 0, 1, 0)

Re: conditional display column in straight table.

tresB — Wed, 13 Dec 2017 06:15:28 GMT

Try like:

=Max(Index(Month, 'Oct'))

With this, even if you select multiple months the expressions would be visible for respective months.