topic Bar chart filtering in QlikView

Bar chart filtering

Thu, 19 Nov 2015 15:33:53 GMT

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

Re: Bar chart filtering

mphekin12 — Thu, 19 Nov 2015 16:06:54 GMT

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

Hope this helps!

Re: Bar chart filtering

Thu, 19 Nov 2015 16:13:20 GMT

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.

Re: Bar chart filtering

mphekin12 — Thu, 19 Nov 2015 16:33:49 GMT

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.

Re: Bar chart filtering

effinty2112 — Thu, 19 Nov 2015 16:35:52 GMT

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!

Re: Bar chart filtering

Thu, 19 Nov 2015 20:46:02 GMT

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

Re: Bar chart filtering

Thu, 19 Nov 2015 20:48:27 GMT

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