Solved: button not working properly in qlikview - Page 2 - Qlik Community

stonecold111 · ‎2017-05-18

Hi qlikss,

i have straight table with field "Sales Flag" which has values

today

yesterday

today

yesterday

i created button for search string =today

it is working when it has value today and yesterday values

but when it has all values like

yesterday

yesterday...... lik this . when i click on button it should show no values. but it is showing all values not filtering anything

how can i do that .. when no today value is there it should show blank straight table

Thankss. qlikss

stonecold111 · ‎2017-05-19

ya it's ok. i will work but for that small change i don't want to do this many changes

is there any other way

stonecold111 · ‎2017-05-23

anyone has answer......

vishsaggi · ‎2017-05-23

Try this in your hi dimension.

= IF(GetSelectedCount(hi) = 0, '', hi)

Find attached.

stonecold111 · ‎2017-05-24

you used normal as search string in yes button

that's y it is working

what my requirement is search string "yes" will be there some days and and won't be there other days in "hi" filed

so whenever there is no single "yes". when i click on yes button it should show empty table.

but it's not filtering anything

qlikview979 · ‎2017-05-24

Hi,

As per my knowledge, if you have 'yes' in hi filed button will work,other wise it will not work.

Regards

stonecold111 · ‎2017-05-24

yes i know that..

but when is no"yes". it should filter table and show empty rows

if its not user will think that it filtered something.

can't we do this small change in qlikview

stonecold111 · ‎2017-05-24

i tried . it's not working

qlikview979 · ‎2017-05-24

Here my doubt is,simple logic

In your data "yes" is not there how can you define "yes" in button. how it will work.

May be,With out association it will not work.

Regards

stonecold111 · ‎2017-05-24

ya. I understtod. This is sample app.

In my requirement, yes will be there in some days and won't be there in other days

i mean after refreshing app,

i think u got my point

stonecold111 · ‎2017-05-24

help me on this