if statement in expression when using dynamic dimension

Wed, 03 Jun 2015 07:22:36 GMT

Hi,

I have the following problem:

The leading dimension in a pivot table is "Priority" (1,2,3,4). Since the customer has SLAs for 1 + 2 and for 3 + 4 I use a dynamic dimension: =If(Priority=1 or Priority = 2, 'Priority 1 + 2', if(Priority=3 or Priority=4,'Priority 3 + 4', 'No Data'))

Now there should be one column with the respective SLA depending on service class and priority. It should be something like if(priority = 1 and serviceclass=1, '96%', if(priority = 1 and serviceclass = 2, 95%,.....)

The point is that this if-statement won't work with my 'Priority 1 + 2' dimension.

Has anyone an idea what might be the solution?

Thank you in advance!

Re: if statement in expression when using dynamic dimension

fvelascog72 — Wed, 03 Jun 2015 07:26:28 GMT

Hi,

If you need a dimension with Priority 1+2 and 3+4 create it in script.

Re: if statement in expression when using dynamic dimension

Wed, 03 Jun 2015 08:32:11 GMT

It's that simple.... thank you!

topic Re: if statement in expression when using dynamic dimension in QlikView

if statement in expression when using dynamic dimension

Re: if statement in expression when using dynamic dimension

Re: if statement in expression when using dynamic dimension