Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Selected values

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

7 Replies
kristof_j
Creator III
Creator III

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

Chanty, might be ad hoc Reports

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

May be like in attached qvw.

Chanty4u
MVP
MVP
Author

Thanx.

But in your Qvw its not working for below 50%

below.PNG

tresesco
MVP
MVP

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
MVP
MVP
Author

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 .

all.PNG

tresesco
MVP
MVP

Like this?