Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Requitrement on If condition

Hi

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,

1 Solution

Accepted Solutions

Re: Requitrement on If condition

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

2 Replies

Re: Requitrement on If condition

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'}>}

Re: Requitrement on If condition

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