Filter Selection by Button in Table

[Anonymous]

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

[Anonymous]

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

[settu_periasamy]

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])

[Anonymous]

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

[settu_periasamy]

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)

[Anonymous]

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

[Anonymous]

Yup, this i could fix by myself

Thanks