topic filtering issue in QlikView

filtering issue

Fri, 06 Jan 2017 11:27:16 GMT

I have a field of 5 item. how do i tie each item to a text or button such that if i click on any it will exclude it from my selections and change the color?

i can also use listbox if its posible to exclude with it

Re: filtering issue

dsharmaqv — Fri, 06 Jan 2017 11:45:57 GMT

Create 5 buttons ans variables for values you want to exclude

Set action Set Variable

and in expression right something like

Sum( { < [Department] = {'*'}-{$(=$(Department01)),$(=$(Department02))} > } Sales)

Re: filtering issue

vinieme12 — Fri, 06 Jan 2017 11:46:52 GMT

This will only complicate things unnecessarily , what are you trying to achieve.

Why not stick with a ListBox with selection style as LED Check box,

Re: filtering issue

Anonymous — Fri, 06 Jan 2017 12:02:08 GMT

Hi,

Please see attached.

Select 1 or multiple items that you want to exclude and then hit the exclude button.

Button > Actions> Add > select excluded > Field = YourFieldName

Hope this helps!

Re: filtering issue

Fri, 06 Jan 2017 12:31:20 GMT

Why i cant use listbox is by default when u select an item it filters based on your selection, what i want is when i select it should exclude the item selected

Clear?

Re: filtering issue

Fri, 06 Jan 2017 12:42:51 GMT

This not it. I have a stack bar chart and i have a field holding 5 items in the stack. i want to use a listbox or buttons to select what i wanna see in the stack

Re: filtering issue

dsharmaqv — Fri, 06 Jan 2017 12:46:24 GMT

have you tried above solution

Re: filtering issue

sunny_talwar — Fri, 06 Jan 2017 12:49:19 GMT

You can try this with list box selection:

If(GetSelectedCount(Item) = 0, Sum(Measure), Sum({<Item = e(Item)>}Measure))

Re: filtering issue

Anonymous — Fri, 06 Jan 2017 13:07:24 GMT

Hi Emma,

It should work with a stack as well. See updated app attached.

Re: filtering issue

vinieme12 — Fri, 06 Jan 2017 13:16:41 GMT

OK, I am trying to understand the use case here

Making an exclusion from a selected field is going to be a two step Process

1) You make the user select a value to exclude

2) You make the user click on another button to confirm the action(Action > Select Excluded )

Another Approach , Is a Single step process for the USER, Where user makes only one selection and

you modify expressions to exclude selections, like stalwar1‌ has demonstrated below.

Your choice!!

Re: filtering issue

Fri, 06 Jan 2017 13:25:36 GMT

its not clear.

Re: filtering issue

sunny_talwar — Fri, 06 Jan 2017 13:32:01 GMT

Like this? Sample qvw attached

Re: filtering issue

Anonymous — Fri, 06 Jan 2017 13:37:37 GMT

Do you want the selected exclusion to only apply to the stack bar and not filter the rest of your application?

Adding on to my previous sample, ive applied Alternate States to do this with instructions in the text box...

See attached.

Hopefully that helps..

Re: filtering issue

Fri, 06 Jan 2017 14:06:18 GMT

Is it possible to replace the listbox with the legend of the chart? As in the customer wants to select with the legend not listbox

Re: filtering issue

sunny_talwar — Fri, 06 Jan 2017 14:37:41 GMT

Yes it should work the same way. Sample attached

Re: filtering issue

Fri, 06 Jan 2017 14:46:42 GMT

No its not exactly as the list works. In the list-box you will check to hide and check again to display. But in the legend immediately you check another option the previous that is hidden displays on its own.

Re: filtering issue

sunny_talwar — Fri, 06 Jan 2017 14:51:07 GMT

I don't think that would be possible

Re: filtering issue

Fri, 06 Jan 2017 15:08:09 GMT