topic Using Set Analysis in QlikView

Using Set Analysis

mustafaelryah — Sun, 01 Feb 2015 08:12:38 GMT

Dear All,

I have the below statement

sum( {$<Account_Type2= {Expenses}>} debit)

its true but when I use value with space it cause an error like below statement:

sum( {$<Account_Type2= {Operational expenses}>} debit)

and when I put it between ' ' the error been removed but no calculation !! like this below:

sum( {$<Account_Type2= {'Operational expenses'}>} debit) or sum( {$<Account_Type2= {[Operational expenses}>} debit) also not calculated !!

Looking forward.

its_anandrjs — Sun, 01 Feb 2015 08:19:29 GMT

Hi,

If Account_Type2 holds value like Operational expenses as string then you have to use SET expression this ways in the single quotes or double quotes.

Sum( {$<Account_Type2= {'Operational expenses'}>} debit)

By this works definitely.

Regards

Anand

mustafaelryah — Sun, 01 Feb 2015 08:26:13 GMT

Kindly review my message , I typed this solution but not calculated !!

its_anandrjs — Sun, 01 Feb 2015 08:31:43 GMT

Can you share any sample file or what string in the Account_Type2 field.

Regards

Anand

Sun, 01 Feb 2015 09:14:01 GMT

Hi Yagoub,

For me sum({$<Account_Type={'Operational Expenses'}>}Debit) is working.

Please find attached.

Thanks,

Chiru