topic Re: Conditional expression in Straight Table in QlikView

Conditional expression in Straight Table

s_herrera_pugli — Sat, 16 Nov 2024 03:35:16 GMT

Hi all,

i want to use a conditional in one of the expressions of my straight table.

I want the metric appear or disappear depending on the field, example

if i have vendor=1 i want the expression to make a sum(), so as if i have vendor=2 but if i have vendor=3 i want to appear nothing like ' '.

I used this expression(obviously didn't work): =if(Vendor= '1', sum([metric_1]), if(Vendor= '2', sum([metric_1]), ' '))

I tried backwards as: =if(Vendor= '3', ' ', sum([metric_1]))

didn't work either.

I hope you could help me!

thanks in advance

Re: Conditional expression in Straight Table

sunny_talwar — Tue, 14 May 2019 14:55:39 GMT

Try this instead

Sum({<Vendor = {'1', '2'}>}[metric_1])

Re: Conditional expression in Straight Table

s_herrera_pugli — Tue, 14 May 2019 15:17:25 GMT

sill doesn't work, it shows the same for all the fields (the sum of the expression) despite the vendor

Re: Conditional expression in Straight Table

sunny_talwar — Tue, 14 May 2019 15:21:16 GMT

Would you be able to show this using an example?

Re: Conditional expression in Straight Table

Vegar — Tue, 14 May 2019 15:47:32 GMT

Have your checked the spelling?

If you are making selections to vendor then you could adjust @sunny_talwar expression like this.
Sum({<Vendor *= {'1', '2'}>}[metric_1])