Using variable for column name in Set Analysis

qlik_venu — Tue, 11 Jun 2013 02:35:32 GMT

Hi,

We have few reports where users have an option to select the Column's. The Column names are provided using a List box. A variable then picks up this value through a variable. ( Var_Project_attribute).

But there are few data in the Selected dimension which needs to be removed in the report. Data like, 'NA', 'NON PROJECT' needs to be hidden /removed only from the selected colum.

This is only for the display purpose. Internally we dont want all the 'NA' to be removed. Its only for the selected dimension the 'NA' need to be removed.

I am get the following to work.

= SUM (IF (upper($(Var_Project_Attribute)) <>'NA' AND upper($(Var_Project_Attribute)) <> 'NON PROJECT', IF ( NATURE_DESCRIPTION <> 'Internal Cost (Actual)', EXPENSES,0),0))

But i am able to see delay in the above report when i change the dimension. When i try a set analysis, it works fine for a dimension like FRANCHISE.

sum({$<FRANCHISE ={'*'} - {'NA', 'NON PROJECT'}, NATURE_DESCRIPTION ={'*'} - {'Internal Cost (Actual)'} >} EXPENSES)

I want to replace the FRANCHISE with the vairable. Var_Project_Attribute. I am not able to get this part. Can you please help me in this.

The following shows error in the expression,

= sum({$<$(Var_Project_Attribute) ={'*'} - {'NA', 'NON PROJECT'}, NATURE_DESCRIPTION ={'*'} - {'Internal Cost (Actual)'} >} EXPENSES)

Thanks,

Venu

Re: Using variable for column name in Set Analysis

Gysbert_Wassenaar — Tue, 11 Jun 2013 06:07:58 GMT

That the expression editor shows an error doesn't mean the expression doesn't work. The syntax checker can get thrown off when you're using variables in place of field names. The expression looks correct to me. Make sure your variable contains the exact field name without any quotes. FRANCHISE is correct, 'FRANCHISE' isn't and Franchise isn't either.

topic Re: Using variable for column name in Set Analysis in QlikView

Using variable for column name in Set Analysis

Re: Using variable for column name in Set Analysis