topic Re: hide unselected items in QlikView

hide unselected items

Tue, 13 May 2014 11:50:36 GMT

Hi all,

i have a straight table something like this:

Salesman All Sales ({Salesman={<'A','B','C','D'}>} sales (only for selected salesman)

A 40 10

B 40 10

C 40 10

D 40 10

when I select a salesman, the table shows all salesmen thanks to the formula for all sales, but with 0 value for unselected items

how can I fix this?

Thanks

Cosmin

Re: hide unselected items

senpradip007 — Tue, 13 May 2014 11:52:35 GMT

can you upload an sample apps?

Re: hide unselected items

Anonymous — Tue, 13 May 2014 12:01:34 GMT

you should define the whole data range using "1" to override the selection of salesman (and everything else)

sum({1<Salesman={'A','B','C','D'}>}Sales

Re: hide unselected items

Tue, 13 May 2014 13:02:58 GMT

I attached

thanks

Re: hide unselected items

Tue, 13 May 2014 13:04:43 GMT

in reality I have more dimensions and I can't do this

thanks

Re: hide unselected items

Anonymous — Tue, 13 May 2014 13:10:05 GMT

It "works as designed". What is the intended behavior?

Re: hide unselected items

Tue, 13 May 2014 13:14:22 GMT

see the attach from the top

when I select just one Salesman I want to see just one on straight table

Thank you

Re: hide unselected items

Anonymous — Tue, 13 May 2014 13:18:52 GMT

In this case your expression for all sales should be:

sum(all Sales)

It's going to ignore all selections.

Re: Re: hide unselected items

Roop — Tue, 13 May 2014 13:21:29 GMT

I have attached a new example. I have detached the Salesman1 value from the table and so can be used to select values. Obviously you would not show the "Salesman" listbox in my example.

So your sales value is now just sum(Sales) and the other value is filtered by the value in Salesman1

Hope it helps

Re: hide unselected items

Anonymous — Tue, 13 May 2014 13:21:55 GMT

One more option

sum({1} total Sales)

It maybe useful if you want not to ignore some selections. In this case you'll add fields "not to ignore" in set

Re: hide unselected items

Anonymous — Tue, 13 May 2014 13:22:25 GMT

Sum({<Salesman=>}Sales)

In your exampel it works

Re: Re: hide unselected items

Tue, 13 May 2014 13:58:53 GMT

I can't see the attach

Re: hide unselected items

Tue, 13 May 2014 14:07:26 GMT

I put your formula but, as you can see, the table contains all salesmen

thanks

Re: hide unselected items

Tue, 13 May 2014 14:12:43 GMT

it's half correct, but if there aren't any selection I want a desagregation for each salesman; it works just when I select one of them

thanks

Cosmin

Re: Re: hide unselected items

Roop — Tue, 13 May 2014 14:19:27 GMT

Last go - simply a text box over the top that can be made to look part of the table - not elegant but may work for you

Re: hide unselected items

PradeepReddy — Tue, 13 May 2014 14:23:00 GMT

Try the bellow expression only in table:

SUM({$<Salesman = {$(=GetFieldSelections(Salesman))}>} Sales)

Re: hide unselected items

PradeepReddy — Tue, 13 May 2014 14:25:15 GMT

Remove the other columns from the table and use the below expression only..

SUM({$<Salesman = {$(=GetFieldSelections(Salesman))}>} Sales)

Re: hide unselected items

Anonymous — Tue, 13 May 2014 14:28:02 GMT

so you want only those salesmen in the table whichhad been selected?

then the following trick will do

define the first expression like that

= if (Sum(Sales)=0,0,Sum({<Salesman={'A','B','C','D'}>}Sales))

set the "suppress when value is null"

and it works !

unfortunately I cannot load up your qvw.

Re: hide unselected items

Tue, 13 May 2014 14:38:31 GMT

yes, this is what I want

I tried to put this as a dimension where I have this option but it return to me a Error in calculation

I don't see where is this option for an expression

thanks

Cosmin

Re: hide unselected items

Roop — Tue, 13 May 2014 14:44:25 GMT

I like this solution a lot - The only change I would make is to change the Salesman={'A','B','C','D'} clause to Salesman= so that you do not need a list of the specific salesmen