Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Rothschild
Contributor II
Contributor II

Set Analasys not equal with varible

Hi,

I try to reach sum(qty) without selected customers.

First I put the selected customers in a varible:

v_cus=chr(39)&Concat(distinct name_customer,chr(39)&','&chr(39))&chr(39)/

Result: 'a','b','c'.

Then I tried to put the varible in not equal formula:

=sum({<name_customer=-{'$(=$(v_cus))'}>}qty)

It does not work.

Do you have an idea?

Labels (3)
9 Replies
Anil_Babu_Samineni

This should work

Variable: LET v_cus = '=chr(39)&Concat(distinct name_customer,chr(39)&'',''&chr(39))';

Expression: =sum({<name_customer-={$(v_cus)}>} qty)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Rothschild
Contributor II
Contributor II
Author

Thanks.

I create the var in the varible overview, Are there changes in syntax?

Anil_Babu_Samineni

Should work from varaible overview as well, Definition should be like below and then try?

=chr(39)&Concat(distinct name_customer,chr(39)&'',''&chr(39))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Rothschild
Contributor II
Contributor II
Author

One chr(39) missed in the beginning. (a','b','c')

Anil_Babu_Samineni

I would rather do simply like this : =Concat(distinct Chr(39) & name_customer & chr(39), ',')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Rothschild
Contributor II
Contributor II
Author

Again, one chr(39) is missing.

Anil_Babu_Samineni

This should work until unless you are doing some wrong? Can you simply try in Text box and share the screenshot?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Rothschild
Contributor II
Contributor II
Author

Maybe does anyone  have a solution??

Anil_Babu_Samineni

Will you be able to share sample application to demonstrate the same?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)