topic Re: RE:Selected values in QlikView

RE:Selected values

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have small pivot table table and one listbox so i want to show the data as per listbox values selection

Listboxvalues

Above50%

Below50%

All

so if i select any value that should be displayed as per selection.

Best

chanty

kristof_j — Tue, 06 Sep 2016 06:54:26 GMT

Hi Chanty 4u

I changed your script a bit and added a dual for your percentages.

Then I changed the dimensions using the dual with a pick statement

Does this help?

Anil_Babu_Samineni — Tue, 06 Sep 2016 07:04:55 GMT

Chanty, might be ad hoc Reports

tresB — Tue, 06 Sep 2016 07:25:43 GMT

May be like in attached qvw.

Chanty4u — Tue, 06 Sep 2016 07:31:11 GMT

Thanx.

But in your Qvw its not working for below 50%

tresB — Tue, 06 Sep 2016 07:38:16 GMT

Small correction. Try:

if(perce='all' or count(perce)>1,actual/trget,

If( Left(perce,5)='above', If(actual/trget>left(right(perce,3),2)/100, actual/trget,0),

if( Left(perce,5)='below', If(actual/trget<left(right(perce,3),2)/100,actual/trget,0))))

Chanty4u — Tue, 06 Sep 2016 09:35:47 GMT

yeah.tresesco‌ its still not working .As expected. And one more thing is i don't want extra column for this ?

how it is possible ?

it showing all values if i select in listbox .

tresB — Tue, 06 Sep 2016 09:46:15 GMT

Like this?