Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculated Dimesion - Syntax

Hi i have a diagram whereby i wish to restrict my dataset to two values.

=if ([Tillv/köp-kod]= 3 and [Tillv/köp-kod] = 6, [Tillv/köp-kod])

however i see that in the column i recieve - as a value.

is the syntax potentially wrong?

Best,

Bradley

1 Solution

Accepted Solutions
sivarajs
Valued Contributor II

Re: Calculated Dimesion - Syntax

If you want only 3 and 6 value you can use

if(WildMatch([Tillv/köp-kod],'3','6'),field1) else if you want the range between 3 and 6 you can go with

if([Tillv/köp-kod]>=3 and [Tillv/köp-kod]<=6,field1)

1 Reply
sivarajs
Valued Contributor II

Re: Calculated Dimesion - Syntax

If you want only 3 and 6 value you can use

if(WildMatch([Tillv/köp-kod],'3','6'),field1) else if you want the range between 3 and 6 you can go with

if([Tillv/köp-kod]>=3 and [Tillv/köp-kod]<=6,field1)

Community Browser