topic Re: Filter Selection by Button in Table in QlikView

Filter Selection by Button in Table

Anonymous — Mon, 24 Aug 2015 13:24:03 GMT

Hi All

Im new on qlikview and i would like to add a button which enables and disables to show the dates with and without the signal code 25/44/45. Is herefore any easy way to realize this?

Thanks for help

rgs Rob

Re: Filter Selection by Button in Table

settu_periasamy — Mon, 24 Aug 2015 17:19:53 GMT

Hi,

Try this..

Create one variable like vShow

Assign this to your Button.. Variable : vShow value: =if(vShow=0,1,0)

in your expression

if($(vShow)=1,only(<[signal code]={25,44,45}>}[signal code]),

only(<[signal code]-={25,44,45}>}[signal code]))

Re: Filter Selection by Button in Table

Anonymous — Tue, 25 Aug 2015 09:29:57 GMT

Hi,

I tried your solution, unfortunately somethign goes wrong. I have also an error highlighted in the expresion.

I have several items on stock with a signal code (1-99), by pushing the button i would like to remove the lines with signal code values 25,44,45

This is what i did according to your insruction

Create one variable like vShow

Assign this to your Button..

Variable : vShow

value: =if(vShow=0,1,0)

expression

if($(vShow)=1,only(<[signal code]={25,44,45}>}[signal code]),

only(<[signal code]-={25,44,45}>}[signal code]))

Result: Item count 501 (unchanged) in both button conditions, signal code disappeared.

Thanks for help

Re: Filter Selection by Button in Table

settu_periasamy — Tue, 25 Aug 2015 09:35:17 GMT

sorry for not including the symbol {

may be try

if($(vShow)=1,only({<[signal code]={25,44,45}>}[signal code]),

only({<[signal code]-={25,44,45}>}[signal code]))

Re: Filter Selection by Button in Table

Anonymous — Tue, 25 Aug 2015 10:13:28 GMT

next issue

Thanks

Re: Filter Selection by Button in Table

settu_periasamy — Tue, 25 Aug 2015 10:17:00 GMT

This is not the Issue.. that will use to exclude the values.

Re: Filter Selection by Button in Table

Anonymous — Tue, 25 Aug 2015 10:20:46 GMT

ok, but the result is sill the same, the button is not clearing the lines, just cancelling the signal codes by adding a - (all).

Re: Filter Selection by Button in Table

settu_periasamy — Tue, 25 Aug 2015 15:54:02 GMT

Hi,

That is depends on the other expression. You have to include/exclude the signal code for other expression too.

is it possible to post the sample qvw file? will try to solve the issue..

Re: Filter Selection by Button in Table

Anonymous — Tue, 25 Aug 2015 16:16:11 GMT

Hi, ok will prepare something, the actual file is way to big, im will be able to create the file tomorrow.

Question; How about if i Edit the dimension Date or %item, to exclude the signal codes? By right the lines with the affected signal codes will automatically disappear, not?

Thanks for your help

Re: Filter Selection by Button in Table

settu_periasamy — Tue, 25 Aug 2015 16:35:19 GMT

Hi,

Try to do that in your expression not in the Calculated dimension, it may be work. But, it will affect the performance as i know.

in your picture, it shows only 2 expression. you can try this..

for average

if($(vShow)=1,Avg({<[signal code]={25,44,45}>}YourField),

Avg({<[signal code]-={25,44,45}>}YourField))

for signal code

if($(vShow)=1,only({<[signal code]={25,44,45}>}[signal code]),

only({<[signal code]-={25,44,45}>}[signal code]))

Re: Filter Selection by Button in Table

Anonymous — Tue, 25 Aug 2015 16:39:41 GMT

This is what i tried today, but unfortunatelly isnt working

if i do it without varriable, it works, i can include and exlude the signal code items, im just not able to include the varriable.

maybe im completely wrong with my itention...

Thansk

Re: Filter Selection by Button in Table

settu_periasamy — Tue, 25 Aug 2015 16:45:09 GMT

You can try this in calculated dimension..

if($(vShow)=1 and [signal code]=25 and signal code]=44 and signal code]=45,%item,%item)

in expression,

=only([signal code])

Re: Filter Selection by Button in Table

Anonymous — Wed, 26 Aug 2015 08:03:56 GMT

Perfect now i get the wished result

Just need to changed a bit to get full assortment (all items) and the active items (no 25,44,45)

For Signal Code

if($(vShow)=1,only({<[Signal Code]-={40,41,42,43,44,45}>}[Signal Code]),[Signal Code])

For average stock

if($(vShow)=1,Avg({<[Signal Code]-={40,41,42,43,44,45}>}#InventoryOnHand),#InventoryOnHand)

As a next step, i will declare the signal code selection in a variable, to make it more easy if i use more expressions as 2.

Thanks again to support a beginner in qlikview

Re: Filter Selection by Button in Table

settu_periasamy — Wed, 26 Aug 2015 08:21:46 GMT

Good to hear that.

do you want the expression with variable?

Create the variable like vSignalCode : 40,41,42,43,44,45

For Signal Code

if($(vShow)=1,only({<[Signal Code]-={$(=vSignalCode)}>}[Signal Code]),[Signal Code])

For average stock

if($(vShow)=1,Avg({<[Signal Code]-={$(=vSignalCode)}>}#InventoryOnHand),#InventoryOnHand)

Re: Filter Selection by Button in Table

Anonymous — Wed, 26 Aug 2015 08:27:20 GMT

As this is not recommended as it slows down the server, im not goin to use it ...

Thanks for the advice in the post before

Re: Filter Selection by Button in Table

Anonymous — Wed, 26 Aug 2015 08:55:30 GMT

Yup, this i could fix by myself

Thanks