Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RCANEDO23
New Contributor

evaluate a measure on different dimensions

Hi Qlik community, 

 

I'd like you to help me with one thing that I have not been able to do. I created a measure called 'Invoiced Weight',  that measure is calculated using the following expression: 

If (chargeable_wiehgt <1, carried_weight, chargeable_weight)

 

If I make a table and see the expression I see that expression is working correctly, nonetheless when I want to see the sum of the 'Invoiced Weight' for any month, what happens is that the formula evaluates the expression as the following if (monthy chargeable weight <1, monthly carried_weight, monthly chargeable_weight)

 

Could anyone advise how could I see the sum of each services' 'Invoiced Weight'?

Labels (1)
1 Reply
MVP & Luminary
MVP & Luminary

Re: evaluate a measure on different dimensions

Sum( if (monthy chargeable weight <1, monthly carried_weight, monthly chargeable_weight) )