topic Re: Problem in calculated dimension in QlikView

Problem in calculated dimension

mishraamit2485 — Wed, 05 Aug 2015 16:01:56 GMT

Hi All,

I'm facing one issue in calculated dimension (Plz see the attached app)

I'm showing the Region and SubRegion both in the same chart depends on the selection.

Now if u select AMS its sub region countries(A,B,C) will come, now if you select A it will show only one row(1 Sub Region Country)

now if you select A again in the chart it should deselect the A and show all the sub regions (A,B,C) again which is not happening in the chart(Chart name is Problem chart in app)

But when i'm taking only subregion directly into the dimension(No Calculated dimension) it works well..click on A(u will see A) then click on A again you will (A,B,C)(Refer sample chart)

Please suggest how to do that:

Re: Problem in calculated dimension

settu_periasamy — Wed, 05 Aug 2015 16:13:48 GMT

Hi,

Can you check this?

Re: Problem in calculated dimension

Gysbert_Wassenaar — Wed, 05 Aug 2015 16:24:39 GMT

A calculated dimension is an expression. If you click on an expression value then all the dimension values used to calculate that value are selected. If you click on that expression again it select the same values again. You cannot deselect these dimension values by clicking the expression value. You have to deselect the dimension values themselves.

Re: Problem in calculated dimension

mishraamit2485 — Wed, 05 Aug 2015 16:26:55 GMT

Awesome Buddy...Great solution