Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

marksmunich
Not applicable

Set Analysis

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

Tags (1)
1 Solution

Accepted Solutions
marksmunich
Not applicable

Re: Set Analysis

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)

4 Replies
tresesco
Not applicable

Re: Set Analysis

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)

kush141087
Not applicable

Re: Set Analysis

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

marksmunich
Not applicable

Re: Set Analysis

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
Not applicable

Re: Set Analysis

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)