topic Re: Requitrement on If condition in QlikView

Requitrement on If condition

Wed, 25 Nov 2020 16:16:04 GMT

i have field name called Quarter in that we have field values Q1,Q2,Q3,Q4, so

1) i have to display only Q1 for Object1(Straight Table1)

2) i have to display only Q12for Object2(Straight Table2)

3) i have to display only Q3 for Object3(Straight Table3)

Note:

i need to filter the data depends on Field Value i.e Q1,Q2,Q3,Q4 etc

Thanks,

sunny_talwar — Tue, 07 Jun 2016 22:12:10 GMT

May be like this

1) Straight table 1's expressions

{<Quarter = {'Q1'}>}

2) Straight table 1's expressions

{<Quarter = {'Q2'}>}

3) Straight table 1's expressions

{<Quarter = {'Q3'}>}

sunny_talwar — Tue, 07 Jun 2016 22:13:27 GMT

Alternatively you can also use calculated dimension if you are using Quarter as one of your dimension:

1) Straight table 1's dimension

If(Quarter = 'Q1', Quarter)

2) Straight table 1's expressions

If(Quarter = 'Q2', Quarter)

3) Straight table 1's expressions

If(Quarter = 'Q3', Quarter)

And then check 'Suppress When Value Is Null' on the dimension tab