Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Bar chart filtering

hi.png

Hello all!

On my graph above, I do not always want to see that fourth bar over, 'Inventory Adjustment'.  I want the chart to default to not have it included in there, but once in awhile I will need to see it.  Any suggestions of what I should do?

Channing

1 Solution

Accepted Solutions
mphekin12
Valued Contributor

Re: Bar chart filtering

Is it just the Inventory Adjustment Code Text that you want removed from the chart?  If so, see the second tab on the attached app, it should at least point you in the right direction.

6 Replies
mphekin12
Valued Contributor

Re: Bar chart filtering


Can you just add a list box and select just those values that you want displayed?  See attached file.

Hope this helps!

Not applicable

Re: Bar chart filtering

Thank you for your suggestion, but the chart is filtered to just show the top 8 (inventory adjustment is usually on that top 8).  I already do have a list box so the user can select a value that is not shown in the top 8. There are so many values of code text in that list box, that I really do not want to hard code, because new values are added all the time.

hello.png

mphekin12
Valued Contributor

Re: Bar chart filtering

Is it just the Inventory Adjustment Code Text that you want removed from the chart?  If so, see the second tab on the attached app, it should at least point you in the right direction.

effinty2112
Honored Contributor

Re: Bar chart filtering

Hi Channing,

I would consider adding a second expression but with a set modifier in it like


<[Code Text] -='Inventory Adjustment'>


You don't want to show both at the same time, you'd prefer to toggle between them so you could create a variable say, vShowInvAdj, that toggles between 0 and 1 and set the display conditions for the two expressions based on the value of this variable.

Set the condition for one to $(vShowInvAdj) and set the other to 1- $(vShowInvAdj).

Make a button with a Set Variable action vShowInvAdj =1-$(vShowInvAdj).

Hope it helps!

Not applicable

Re: Bar chart filtering

Yep! Just the inventory adjustment code text.  Did you attach an app?

Not applicable

Re: Bar chart filtering

Nvm I see the attachment in this view haha.  Thanks so much!

Community Browser