Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Why you want to add field name there? Can you tell me what is the purpose?
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)
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)