topic Re: HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE in QlikView

HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE

sadiaasghar — Sat, 16 Nov 2024 18:08:08 GMT

I want to hide total row/partial sum from mini circular gauge chart column in qlikview pivot table and also want to reposition chart in the centre of cell. I have tried dimensionality and also rowno()=0 condition with expression but it's not hiding partial sum chart. Please guide regarding circular mini chart position setting and how to hide only partial sum chart.

Re: HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE

sadiaasghar — Tue, 08 Sep 2020 17:41:37 GMT

@Kushal_Chawda @sunny_talwar please have a look

Re: HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE

sunny_talwar — Tue, 08 Sep 2020 19:01:32 GMT

I can't find a way to do this, may be @Kushal_Chawda can help

Re: HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE

Kushal_Chawda — Tue, 08 Sep 2020 21:56:58 GMT

@sadiaasghar as sunny mentioned I don't think it is possible. may be possible with macro but need to do some research on that. But one trick you can do which is of course not ideal solution but you can place the text object over the total with top layout which will hide gauge. You need to make all possible combination of selections so that you can place the text objects there with show and hide condition.

Re: HIDE TOTAL ROW FROM MINI CIRCULAR GAUGE CHART IN QLIKVIEW PIVOT TABLE

sadiaasghar — Fri, 11 Sep 2020 06:24:32 GMT

@Kushal_Chawda @sunny_talwar can we specify different color segment ranges based on a project in mini circular gauge chart like if the project is HSD Vol. the value for segment 1 should be 0.97 instead of 0, for segment 2 it should be 0.1 instead of 0.25 and so on.