Discussion Board for collaboration on QlikView Layout & Visualizations.
I am using a calculated dimension in a Pie chart as follows:
=IF(Message_Type = 'Error', 'Error' , 'Success')
The above 'IF' statement is working fine. But now the requirement got changed.
Now I have to include following Message_Types: Error, Warnings, Completed in the Pie Chart. But if Message_Type is not equal to Error, warnings, Completed it should flag as Success.
I'm not sure I understand. Maybe this?
If so, I'd do this in the script, making some new field like Message_Group. I prefer more complicated script and simpler charts. It's better for chart performance.