topic Re: Calculate expression if single field selected in QlikView

Calculate expression if single field selected

Tue, 13 Jan 2015 10:34:20 GMT

Hello,

I am creating a table where I would like a column to show a Monthly calculation if a single month is selected. If no month or multiple months are selected, this column should show nulls.

Can anyone help with syntax for something like this? I'm presuming I would add it to the 'Conditional' box for expressions?

Thanks very much.

Mel

Re: Calculate expression if single field selected

tresB — Tue, 13 Jan 2015 10:40:21 GMT

May be simply a conditional expression like:

Count(Distinct MonthField)=1

Re: Calculate expression if single field selected

Tue, 13 Jan 2015 10:45:37 GMT

Hi,

Yes, you are right.

You can write the general expression for calculation and then Force the Chart to be displayed on the selection of a Distinct Month Value as tresesco has suggested i.e.

Count(Distinct MonthField)=1

Cheers !

Re: Calculate expression if single field selected

kavita25 — Tue, 13 Jan 2015 10:48:42 GMT

Hi,

Try this in your Expression. Hope it helps you.

=if(GetSelectedCount(MonthField)=1,sum(Value), '-')

Regards,

kavita