topic Calculated dimension with multiple if statements in QlikView

Calculated dimension with multiple if statements

Tue, 20 Dec 2016 12:49:10 GMT

I want to show a single calculated dimension which meets the following conditions :

IF BUSINESS_UNIT ='SALES'

IF REGION LIKE 'AMERICAS*',

IF SALESPERSON LIKE 'JOHN*',

Need some help constructing this statement with the correct syntax please.

Re: Calculated dimension with multiple if statements

Anonymous — Tue, 20 Dec 2016 12:54:44 GMT

try

if (match(BUSINESS_UNIT,'SALES')>0 and match(REGION, 'AMERICAS')>0 and match(SALESPERSON, 'JOHN')>0, yourcalulateddimension)

Re: Calculated dimension with multiple if statements

Tue, 20 Dec 2016 13:05:22 GMT

Awesome thanks. On the presentation side is there an easy way of hiding the dimension and expression labels ?

Re: Calculated dimension with multiple if statements

Anonymous — Tue, 20 Dec 2016 13:10:53 GMT

on either tab Dimension and Expression you may untick the Labels (or give own descriptions)

Re: Calculated dimension with multiple if statements

Tue, 20 Dec 2016 13:19:43 GMT

Sure, mine is showing as greyed out in the dimensions tab though

Re: Calculated dimension with multiple if statements

Anonymous — Tue, 20 Dec 2016 13:31:21 GMT

it depends on the Chart type. a Pivot table you may Change the description but you cannot be without Label (you may define an empty text). in a barchart you may design your Chart without a label