Set analysis

[madhuqliklondon]

Hi

I am trying to achieve ,I want to show only  Type = 'standard 'and exclude brand = gim', I am using below expression but its not working.

Sum({<[Master SKU no_]={'*'},[Product Type]={'Standard'},[Brand name] - ={'gim'}>}1)

See below picture those headers are labelled names.

Set analysis meant to use on original field names or labelled names . The above expression is done on original field names. Help please.

[Anil_Babu_Samineni]

Make sure, Set analysis reads as Case Sensitive. Please check whether CHANEL is Chanel or Something. Then use the same

[Sergey_Shuklin]

Hi, Madhu!

Are you using only this one expression in the straight table? There might be other expressions with crossing conditions.

If there is no other expressions, can you place a piece of source table, please?

[madhuqliklondon]

Hi, I am trying to do this in live dashboard, but created new straight table, and using only one expression. I will screen shot for sure.

[shiveshsingh]

Please share some source code/file.

one more thing you have to keep in mind, qlikview is case sensitive!!

[Sergey_Shuklin]

Hi, Madhu!

Sometimes it helps to undertand the reason of unworking expression is separate it by parts.

For instance:

Can you tell me, please, is this expression Sum({<[Product Type]={'Standard'}>}1) works?

[tyagishaila]

Hi Madhu,

Are you sure your expression is OK,

Try it

Sum({<[Master SKU no_]={'*'},[Product Type]={'Standard'},[Brand name] =- {'CHANEL'}>}1)

[jonathandienst]

Take out the space between the - and =:

Sum({<[Master SKU no_]={'*'}, [Product Type]={'Standard'}, [Brand name] -={'CHANEL'}>}1)

                                                                                                         ^^^

[madhuqliklondon]

Yes, it is working now . It did not work because i was using just field name, I tried with tablename.fieldname  and its working fine now.  Thank you all for quick qlik suggestions and support.