Pie Chart (Calculated Dimension)

hkg_qlik — Fri, 08 Jul 2011 16:24:05 GMT

Hi,

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.

Please advise

Regards,

Re: Pie Chart (Calculated Dimension)

johnw — Sat, 09 Jul 2011 00:12:46 GMT

I'm not sure I understand. Maybe this?

=if(match(Message_Type,'Error','Warnings','Completed'),'Error','Success')

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.

topic Pie Chart (Calculated Dimension) in QlikView

Pie Chart (Calculated Dimension)

Re: Pie Chart (Calculated Dimension)