Discussion Board for collaboration on QlikView Layout & Visualizations.
I created a list box, made a IF expression in General>Field, and made a Sum() expression. If I didn't make any selction, it would display
If I selected Sales it would display
How can I get it to display
=if(GetFieldSelections(FieldName) = 'Forecast ',Expression ,0)
Thank you, but the values in the list box are not fixed, it could also be "Hold", "CB"... Is there any more flexible way on this?
Please share a demo file.
assuming the field you are summing is called 'Value' then you could do something like:
Please find the attached file
Seems it doesn't work...
Upload a test qvw, I want '0' displayed rather than blank when making some selection.
I have attached a test file.
I have updaloaded a test qvw.
Please find the attachment, it may helps you