Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jakobjosef
Contributor

dynamic Status_Show Names with Status "x" or "y".

Hello dear QV-Community,

may I ask you for help?

Following problem:
I would like to show the sales-value of all employees with the status "planned" and the status "unplanned".

I am able to manage to show them separately (one table for planned one for unplannend).

My dynamic dimension is like:

=if ( status = 'planned', employeeName)

for values it s just "Sum(Sales)".

this works for  'unplanned' as well.

I would like to show 'unplanned' and 'planned' in one table, so i tried to type my dynamic dimension like:

=if (status = 'planned' or 'unplanned', employeeName).


But unfortunately this doesnt work. Does anyone know who I can combine both statuses?

Thank you for your help.

Greetings
Jakob

1 Solution

Accepted Solutions
Highlighted
sibin_jacob
Contributor III

Re: dynamic Status_Show Names with Status "x" or "y".

Write like this


=if (status = 'planned' or status ='unplanned', employeeName).

4 Replies
Highlighted
sibin_jacob
Contributor III

Re: dynamic Status_Show Names with Status "x" or "y".

Write like this


=if (status = 'planned' or status ='unplanned', employeeName).

mohammed_aquib
New Contributor III

Re: dynamic Status_Show Names with Status "x" or "y".

Try using the code below:

In 'Dimension' tab, add a calculated dimension and type the following:

=value list('Planned', 'Unplanned')

In 'Expressions' tab, add the following two expressions:

1. if(value list('Planned', 'Unplanned')='Planned', sum(if(status='Planned', Sales)))

2. if(value list('Planned', 'Unplanned')=Unplanned', sum(if(status='Unplanned', Sales)))

jakobjosef
Contributor

Re: dynamic Status_Show Names with Status "x" or "y".

i already solved it on my own:

=if(status = 'planned' OR status = 'unplanned', employeeName)

jakobjosef
Contributor

Re: dynamic Status_Show Names with Status "x" or "y".

THANK YOU so much for your quick(view) help