Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
Write like this
=if (status = 'planned' or status ='unplanned', employeeName).
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)))
i already solved it on my own:
=if(status = 'planned' OR status = 'unplanned', employeeName)
THANK YOU so much for your quick(view) help