Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

calc condition using field in an alternate state

Hi all,

I have a pie chart that i am trying to set up a calculated condition on..

I dont want it to calculate if a selection on 'Residency' ='Overseas' so i have done the following..

If(Residency='Overseas',1,0)

this works as expected, but the field 'Residency' needs to be in an alternate state (Comp1). how can i add this into the if statement?

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If( only({Comp1} Residency) ='Overseas',1,0)

View solution in original post

2 Replies
swuehl
MVP
MVP

If( only({Comp1} Residency) ='Overseas',1,0)

sibideepak
Creator II
Creator II

HI hopkinsc,

try ,

if([Comp1]Residency='Overseas',1,0)

or

try

as swuehl told

If( only([Comp1] Residency) ='Overseas',1,0)