topic Re: Selection only in one dimension in QlikView

Selection only in one dimension

Tue, 23 Apr 2013 08:52:52 GMT

Hi,

I have a chart with 3 dimensions and i want to let users to make selections only using the first dimension ignoring the others.

Is it possible?

Re: Selection only in one dimension

kaushiknsolanki — Tue, 23 Apr 2013 10:06:35 GMT

Hi,

Not clear about what you want, kindly explain with example.

Regards,

Kaushik Solanki

Re: Selection only in one dimension

Tue, 23 Apr 2013 11:49:34 GMT

Hi,

Suppose we take 3 dimension such as Company,Type & Mode &
Then you can select Company ....then selection will affect but if You select from Type & Mode then these Selection will not affect to the chart.
So you can use this expression.....

=Sum({<Type=,Mode=>} Premium)

Re: Selection only in one dimension

Tue, 23 Apr 2013 12:17:25 GMT

So you suggest to solve the problem with set of analysis on the expressions.

I just wondering if you have other options to solve this on the client lvl.

Re: Selection only in one dimension

er_mohit — Tue, 23 Apr 2013 12:31:05 GMT

Try this

make variable

v1=(SubField(GetcurrentSelections(),':',-1))

then use that v1 in expression

whatever you want

Re: Selection only in one dimension

Tue, 23 Apr 2013 12:31:40 GMT

go to properties of chart--> dimension --> edit group-->new

then select your field which you want to take as dimension

select cyclik group, then ok so a toggle had made.

now add this toggle as dimension.

then add expression

now u select any one from toggle. then on the basis of this u see the output

Re: Selection only in one dimension

Wed, 24 Apr 2013 07:27:56 GMT

ooops....

The solution was under my nose...

Just need to make the two others dimensions --> expressions...