topic Re: Set analysis in QlikView

Set analysis

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Set analysis

Anil_Babu_Samineni — Tue, 09 May 2017 15:29:32 GMT

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

Re: Set analysis

Sergey_Shuklin — Tue, 09 May 2017 15:44:33 GMT

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?

Re: Set analysis

madhuqliklondon — Tue, 09 May 2017 16:00:23 GMT

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.

Re: Set analysis

shiveshsingh — Tue, 09 May 2017 16:31:23 GMT

Please share some source code/file.

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

Re: Set analysis

Sergey_Shuklin — Wed, 10 May 2017 04:26:34 GMT

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?

Re: Set analysis

tyagishaila — Wed, 10 May 2017 04:42:42 GMT

Hi Madhu,

Are you sure your expression is OK,

Try it

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

Re: Set analysis

jonathandienst — Wed, 10 May 2017 04:54:11 GMT

Take out the space between the - and =:

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

^^^

Re: Set analysis

madhuqliklondon — Wed, 10 May 2017 13:07:27 GMT

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.