Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have an expression that I am using in a table.
=SUM(IF(PriceScale = 'LevelA', QTY).
I want to introduce an additional piece of logic to this expression.
I have an inline table
My end goal is to be able to say that if 300 tickets have been sold to LevelA, there is a remaining capacity of 700.
My dimension for my table is the PriceScale.
Yes .. It's because you have specified A in the expression Capacity - SUM(IF(PriceScale = 'LevelA', QTY))
TO get for all try below
Capacity - SUM(QTY)
View solution in original post
My visualization is a straight Table (as below)
The expression works, but only for LevelA, as we are calling that out in the expression. How can we make this apply to all?