if - chart function

[AlejandroJuarez]

Hello I need help with this table, I think it would be the function IF

state	price total
A	0		if 'price total' = 0 and state A ( calcule 1)
B	0		if 'price total' = 0 and state B ( calcule 2)
C	0		if 'price total' = 0 and state C ( calcule 3)
D	0		if 'price total' = 0 and state D ( calcule 4)

[MayilVahanan · Accepted solution]

Hi

Try like below

if('price total' = 0 ,

pick(Match(state, 'A', 'B', 'C', 'D'), Calc1, calc2, calc3, calc4))

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunc...