topic Re: requirement in QlikView

requirement

Anonymous — Tue, 15 May 2018 06:53:27 GMT

i have a stackedbar chart,where one of the dimension value is bit high,so I want to supress that value,

like suppose I have a button and if I click on that button the value for that particular dim gets added to my stacked bar ,

how to do that

Re: requirement

pradosh_thakur — Tue, 15 May 2018 06:58:02 GMT

Post a sample please. It will save time and will make things easier.

Re: requirement

Anonymous — Tue, 15 May 2018 07:06:16 GMT

Re: requirement

Anonymous — Tue, 15 May 2018 07:31:39 GMT

I need to suppress these high values in pink,and when I click on button these values shud be added in a stacked chart,in bydefault view it shud be excluded,

Re: requirement

pradosh_thakur — Tue, 15 May 2018 07:41:22 GMT

that i understand. I asked for sample data or a dummy app replicating this if you have.

Re: requirement

Anonymous — Tue, 15 May 2018 07:44:54 GMT

SORRY CANT SHARE THAT,

can you please help with the logic and functionality?

Re: requirement

pradosh_thakur — Tue, 15 May 2018 08:09:51 GMT

i understand you cant share data but encourage you to prepare a sample with dummy data which will make things easier.

Anyways.

use 3 dimension.

1st - A

2nd- B with conditional show hide $(v_1)=0

3rd- =if(B='PINK DIMESNION',null(),B) with conditional show hide $(v_1)=1

Create a variable v_1

two buttons

1st button- set v_1 to 0

2ND Button set v_1 to 1

you are good to go.. See how hard to describe logic like this. Sample make things easier.

regards

Pradosh

Re: requirement

Anonymous — Tue, 15 May 2018 10:21:59 GMT

and if we have 3 buttons,will it wotk in that case

Re: requirement

pradosh_thakur — Tue, 15 May 2018 11:12:26 GMT

For what do you need 3rd button for ?

Please mark helpful and correct answer appropriately so that it can help others in future.

Re: requirement

Anonymous — Wed, 16 May 2018 05:52:08 GMT

my issue is

I already have two buttons and variables defined

say vaddress

vproducts

so when I click on button 1 vaddress=1

I get count of addressids in my stacked bar,

and on the second button vproducts=1 I get count of productids in my stacked bar (x axis is same ,there is changein expressions),

so not for adding this hide functionality,how I shud go,

shud I add the third button with a new variable defined ,and then where I shud put the condition,:3rd- =if(B='PINK DIMESNION',null(),B)

its bit urgent kindly help

Re: requirement

pradosh_thakur — Wed, 16 May 2018 06:07:03 GMT

Ahh.. The button you have created will not impact the approach i told.

As i told

1:update the dimensions as i have described with condition in variable.(Instead of pink dimension you need to write the value of the pink dimension)

2: Create the variable

3: Set the variable (you need to add 2 more buttons 1 for setting v_1 to 0 and other to set it to 1)

if you find difficulty attach screenshot or expression.