topic Same dimension, same measure, different values. in App Development

Same dimension, same measure, different values.

rotter — Fri, 05 May 2023 19:53:25 GMT

I have a problem and I need a help to solve it, please.

My dashboard has two charts: bars and pie. Both are using the same dimension and measure, however, the labels/results are different.

Dimension: SIGLA OCUPANTE
Measure: Count(distinct [Cód Bem Imóvel])/Count(total distinct [Cód Bem Imóvel])

I don't know if it has a direct impact, but it's important to say that 'SIGLA OCUPANTE' can have more than one '[Cód Bem Imóvel]'.

If anyone can help me, I appreciate it.

Kushal_Chawda — Fri, 05 May 2023 20:22:59 GMT

@rotter do you know which one is correct?

rotter — Mon, 08 May 2023 11:56:18 GMT

The bar chart is correct, as it considers the total with the distinct values.

rotter — Mon, 08 May 2023 19:16:54 GMT

Issue solved.

I've changed the "Value Labels" from 'Automatic' to 'Personalize' and then 'Values'.

(My QlikSense version is in Portuguese, so I'm sorry if I wrote wrong the options).