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

[settu_periasamy]

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

[Anonymous]

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

[settu_periasamy]

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

[Anonymous]

next issue

Thanks

[settu_periasamy]

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

[Anonymous]

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

[settu_periasamy]

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..

[Anonymous]

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

[settu_periasamy · Accepted solution]

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