Set Analysis

[marksmunich]

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

[tresesco]

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)

[Kushal_Chawda]

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

[marksmunich · Accepted solution]

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)

[marksmunich]

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)