button not working properly in qlikview

[stonecold111]

Hi qlikss,

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

                                                               today

                                                                yesterday

                                                                today

                                                                yesterday

                                                                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

[prieper]

an example would be helpful ....

[Anonymous]

Hi

Please post sample

[Anonymous]

Hi

If matching records available in Straight table then only it will filter accordingly or else that action will not work for Button

Hope it helps!!

[stonecold111]

yes u got my point.. if there are no match values it should show empty table

becase my user getting confused for this

how to achieve this

[Sergey_Shuklin]

Hello, Suresh!

You can do this:

Create variable vVar with value 1 (or 0 it's doesn't matter). Then create second variable vDim with the expression:

if(vVar=1,if([Sales Flag]='today',[Sales Flag],null()),[Sales Flag]).

Then go to your straigt table and use the calculated dimension:

=$(vDim)

On button set an action External-Set Variable with condition: if(vVar=1,0,1) for variable vVar.

Now, when you'll click a button your result table will get a calculated dimension values today and nothing, or all fields. If there is no today it will return null.

[stonecold111]

where can i add my sample app?????

[prieper]

used advanced editor (and then on the lower right)

Peter

[Anonymous]

Click on " Use Advance Editor " you will get attachment option

[stonecold111]

click on yes button

should show blank table