topic Re: button not working properly in qlikview in QlikView

button not working properly in qlikview

stonecold111 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: button not working properly in qlikview

prieper — Thu, 18 May 2017 09:54:47 GMT

an example would be helpful ....

Re: button not working properly in qlikview

Anonymous — Thu, 18 May 2017 09:58:57 GMT

Please post sample

Re: button not working properly in qlikview

Anonymous — Thu, 18 May 2017 10:10:14 GMT

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

Re: button not working properly in qlikview

stonecold111 — Thu, 18 May 2017 10:14:50 GMT

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

Re: button not working properly in qlikview

Sergey_Shuklin — Thu, 18 May 2017 10:15:49 GMT

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.

Re: button not working properly in qlikview

stonecold111 — Thu, 18 May 2017 10:18:02 GMT

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

Re: button not working properly in qlikview

prieper — Thu, 18 May 2017 10:25:35 GMT

used advanced editor (and then on the lower right)

Peter

Re: button not working properly in qlikview

Anonymous — Thu, 18 May 2017 10:26:44 GMT

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

Re: button not working properly in qlikview

stonecold111 — Thu, 18 May 2017 10:48:35 GMT

click on yes button

should show blank table

Re: button not working properly in qlikview

stonecold111 — Fri, 19 May 2017 09:33:59 GMT

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

Re: button not working properly in qlikview

stonecold111 — Tue, 23 May 2017 14:24:28 GMT

anyone has answer......

Re: button not working properly in qlikview

vishsaggi — Tue, 23 May 2017 14:57:45 GMT

Try this in your hi dimension.

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

Find attached.

Re: button not working properly in qlikview

stonecold111 — Wed, 24 May 2017 04:47:22 GMT

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

Re: button not working properly in qlikview

qlikview979 — Wed, 24 May 2017 05:23:58 GMT

Hi,

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

Regards

Re: button not working properly in qlikview

stonecold111 — Wed, 24 May 2017 05:32:07 GMT

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

Re: button not working properly in qlikview

stonecold111 — Wed, 24 May 2017 05:32:54 GMT

i tried . it's not working

Re: button not working properly in qlikview

qlikview979 — Wed, 24 May 2017 05:43:24 GMT

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

Re: button not working properly in qlikview

stonecold111 — Wed, 24 May 2017 05:48:37 GMT

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

Re: button not working properly in qlikview

stonecold111 — Wed, 24 May 2017 06:20:07 GMT

stalwar1‌

help me on this