topic Re: Set Analysis in QlikView

Set Analysis

marksmunich — Fri, 26 Jun 2015 11:14:05 GMT

Hello Qlik's,

in the following example, is it possible to have a fieldname in the place of identifier ? normally we provide 0,1,$,$1,$-1, bookmark as identifier.

sum([Field name]<CategoryName={’Babywear’}>} sales)

Thanks

Regards

Mark

Re: Set Analysis

tresB — Fri, 26 Jun 2015 11:25:29 GMT

No, qv won't accept field name there. However, you could probably achieve your goal with a different approach. If you want to disregard one field selection, you could try like:

sum({<[Field Name]=, CategoryName={’Babywear’}>} sales)

Re: Set Analysis

Kushal_Chawda — Fri, 26 Jun 2015 11:27:58 GMT

Why you want to add field name there? Can you tell me what is the purpose?

Re: Set Analysis

marksmunich — Fri, 26 Jun 2015 11:38:09 GMT

Thanks a lot for the quick responsetresesco‌ . It was indeed an alternate state combined with Set analysis. I was confused a bit. I thought it was a field name.

sum([Alternate state]<CategoryName={’Babywear’}>} sales)

Re: Set Analysis

marksmunich — Fri, 26 Jun 2015 11:40:58 GMT

problem solved. It was not the field name. It was in deed an Alternate state. I was confused alternate state with a field name.

=sum({[Alternate State1]<country{'SWEDEN'}>} Revenue)