topic Re: set analysis using fact as dimension or a variable in QlikView

set analysis using fact as dimension or a variable

Fri, 31 Jan 2014 06:37:08 GMT

Hi,

I have a following expression. Based on a button the variable var changes

if( var=DATE_FY, sum({<DATE_FY={'2013'}>}AMOUNT),sum({<DATE_CY={'2013'}>}AMOUNT))

I want to remove the if condition from the expression. So I create a Inline table Period with values as DATE_CY, DATE_FY and trying to use them in my expression. By default Period is DATE_FY.

=sum({<$(Period)={'2013'}>}AMOUNT)

This doesn't seem to work.

Is there a way to make this work ?

Thanks

Lax

Re: set analysis using fact as dimension or a variable

er_mohit — Fri, 31 Jan 2014 06:56:20 GMT

You have to write two expressions

=sum({<DATE_FY={'2013'}>}AMOUNT)

For this in conditional check on it and write =Period='DATE_FY' in Conditional is

and same for other expression sum({<DATE_CY={'2013'}>}AMOUNT)

and in conditional write =Period='DATE_CY'

hope it helps

when you select in list box it works

Re: set analysis using fact as dimension or a variable

Fri, 31 Jan 2014 07:31:10 GMT

Hi,

I wish to use single expression only.

Thanks

Lax