topic Compliance % Based on Dimension in QlikView

Compliance % Based on Dimension

joshibabu_are — Mon, 20 Feb 2017 08:15:09 GMT

Hi Guru's,

I want to display Course Status Wise Compliance % in PIVOT Table,

Here i want to show 89.80 in Both Compliance % Place

98.92 is showing wrong %.

Thanks,

Joshi

adamdavi3s — Mon, 20 Feb 2017 08:29:27 GMT

Just change your expression to match your dimension logic:

joshibabu_are — Mon, 20 Feb 2017 09:31:16 GMT

Hi Adam,

Thanks for your Time.

its working with selections but if i clear selections its not working as expected.

adamdavi3s — Mon, 20 Feb 2017 10:48:28 GMT

Hmm yes its a dimensionality issue, I will have to ponder this

Just an FYI but the data seems to have quite a lot of personal information in it so I have taken the qvw off my answer