Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

hkg_qlik
Contributor II

Pie Chart (Calculated Dimension)

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,

H

1 Reply
MVP
MVP

Re: Pie Chart (Calculated Dimension)

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.

Community Browser