topic Re: Button to Exclude Sales by Color Name in QlikView

Button to Exclude Sales by Color Name

Tue, 07 Oct 2014 14:42:14 GMT

Hi,

I'm trying to create a button that will exclude colors "MISC' and "NA" from my selections, so that I can view my Gross sales ( we have several hundred colors, I want to exclude 2). All of the other discussions involving buttons I have read have either been date based where you can use things like "today(-1)" or included an attached .qvw that I'm somehow unable to open, so any written description is very much appreciated - thanks

Re: Button to Exclude Sales by Color Name

maxgro — Tue, 07 Oct 2014 14:47:22 GMT

maybe with 2 actions in the button (chenga field and values in image)

select in field (color (MISC|NA)

select excluded

Re: Button to Exclude Sales by Color Name

Tue, 07 Oct 2014 14:55:15 GMT

Worked like a charm - thank you for the visual!

Side note - how did you type the vertical line you used as a separator between the colors? I ended up just copy and pasting it from your comment into my search string

Re: Button to Exclude Sales by Color Name

Anonymous — Tue, 07 Oct 2014 14:57:31 GMT

<Shift> \

should give you the | aka pipe.

[At least on my laptop]

Re: Button to Exclude Sales by Color Name

Tue, 07 Oct 2014 15:18:08 GMT

Works on my desktop as well - thanks!

Re: Button to Exclude Sales by Color Name

maxgro — Tue, 07 Oct 2014 15:31:46 GMT

When you think you get the answer, please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios. Thanks and good Qlik.