topic Re: only one value selection in list box in QlikView

only one value selection in list box

prma7799 — Mon, 20 Jul 2015 05:04:16 GMT

Hi All,

Kush141087‌

I have one list box and have sorting expression then i will get top 10 values from there.

but issue is when i going selection one value all other values become hide.

the below screenshot is list box having top 10 divi

and this is after selecting any one i am getting below values all values get hide.

Re: top 10 values

Thanks

Re: only one value selection in list box

tresB — Mon, 20 Jul 2015 05:47:54 GMT

Where do you wish to select, in the calculated list box (ranked one) or the field iteself? could you post your working sample qvw?

Re: only one value selection in list box

prma7799 — Mon, 20 Jul 2015 05:50:44 GMT

Hi Tresesco,

I want to select on calculated list box.

for sample apps its is not possible to attache.

Thanks

Re: only one value selection in list box

tresB — Mon, 20 Jul 2015 05:55:00 GMT

May be this can help: Preparing examples for Upload - Reduction and Data Scrambling

Re: only one value selection in list box

prma7799 — Mon, 20 Jul 2015 06:08:20 GMT

Hi Tresesco,

My requirement is when i am selecting one division then it will show me all remaining division in grey format.

Thanks

Re: only one value selection in list box

Kushal_Chawda — Mon, 20 Jul 2015 06:30:28 GMT

Hi,

In front end we have calculated expression using Rank function, so when you select any values from that listbox it will satisfy the condition for that selection only and for rest values will be null so it will not display as we have used aggr function.

One way could be, calculate the Top10 flag from back end. See the attached application for that.

or may be jagan‌ or swuehl‌can help you solve this issue.

Re: only one value selection in list box

tresB — Mon, 20 Jul 2015 06:48:42 GMT

Instead of list box, take a staright table; use the expression without aggr() to rank and restrict your data set; hide the expression in the presentation tab. See attached sample.

Re: only one value selection in list box

prma7799 — Mon, 20 Jul 2015 07:09:46 GMT

Hi Tresesco,

Thanks for your reply but but i required only list box there.

Thanks

Re: only one value selection in list box

swuehl — Mon, 20 Jul 2015 07:21:43 GMT

in a listbox, use

= aggr(if(rank(sum({<Division >} Amount),4)<=10, only({<Division>} Division)),Division)

Re: only one value selection in list box

prashantbaste — Mon, 20 Jul 2015 07:24:54 GMT

As per my understandings, your issue is of data reduction after selection of any value.

So you can use SET ANALYSIS expressions to calculate Sum of Value/Amount

For eg. If dimension is STORE, then expression can be written as - Sum({<STORE>} Amount)

This will sum amount with Store wise & from Dimension limits you can restrict Top 10 values. Also in chart when you will select any one value still it will show all values.

Hope this will be helpful.

Regards,

Prashant P Baste

Re: only one value selection in list box

Kushal_Chawda — Mon, 20 Jul 2015 07:42:58 GMT

Hi swuehl,

Below expression also works

=aggr(if(rank(sum({1}Amount),4)<=10, only({1}Division)),Division)

Re: only one value selection in list box

swuehl — Mon, 20 Jul 2015 07:48:48 GMT

It technically works, but semantically it's different, it will show always the top 10 customers disregarding any selections, like on time dimensions, product dimensions etc.

Using

=aggr(if(rank(sum({<Division>}Amount),4)<=10, only({<Division>}Division)),Division)

is hence closer to the original list box, just showing all Division values even when there is a selection in that field.

Re: only one value selection in list box

Anonymous — Mon, 20 Jul 2015 08:34:43 GMT

Hi,

There is a Front End work around by:

create a Straight table with

In Dimensions Tab

1.1. Dimension = Division

1.2 check show all values

1.3 in division background colour make the expression:

=if(sum({1<Division = p(Division)>}Amount)>1,$(ActiveColour),$(InactiveColour))

2. In Expressions Tab

2.1 Make Expression:

=sum({<Division=>}Amount)

3. in Presentations Tab

3.1 Select the expression

3.2 click on Hide Column Radio button

4. In the Dimension Limits Tab

4.1 check restrict values which are shown

4.2 select show largest 10 values

4.3 deselect show others

This will now allow you to have list of the top 10 divisions based on Amount which will change based on any selection and will allow you to choose a division to view the rest of the data with the chosen division. it will not auto hide the unselected divisions.

Hope this helped

Gareth