topic multi Dimensions in a pie chart in QlikView

multi Dimensions in a pie chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to get a pie chart working with just Dept_code = 123 and count(CertificationName)

I assume that i create a dimension what not sure on the code.

Anil_Babu_Samineni — Wed, 27 Dec 2017 16:32:08 GMT

May be this

If dimension, If(Dept_code=123, Dept_code) // Suppress should be enable

If expression, count({<Dept_code = {123}>} CertificationName)

Anonymous — Wed, 27 Dec 2017 16:36:40 GMT

Thank you, count({<Dept_code = {123}>} CertificationName) worked perfectly

Anil_Babu_Samineni — Wed, 27 Dec 2017 16:49:54 GMT

Glad it worked, But we will get from community related same stuff.