topic Re: Buttons! in QlikView

Buttons!

Wed, 14 May 2014 14:24:22 GMT

Hi everyone,

Hoping someone can help me with buttons!

I am creating a QV dashboard to show how long people are waiting for their issues to be resolved. I want a button which will change the list to show:-

All unresolved issues (where date closed is null)

All resolved issues (where date closed is not null)

All issues which are unresolved and has been 30 days since logging.

Can someone help me? I've tried different things with Select in Field but I'm not getting it right

Thanks muchly

Natalie

xXx

Re: Buttons!

Wed, 14 May 2014 14:40:54 GMT

You can add a Action (Select in Field) to the Button select the depending Values (for example Open)

Re: Buttons!

jolivares — Wed, 14 May 2014 14:41:04 GMT

I suggest that you assign a status during a script run. In this case every call has a status and in your dashboard just put a list box from which you can select a specific value.

Otherwise, what your want it is possible to do from within the dashboard, but i recommend to do in the script.

If you need more help... post some data in order to see what is happening.

Re: Buttons!

Anonymous — Wed, 14 May 2014 14:45:24 GMT

Try these:

Open calls (no close date):
Select in Field Call ID with search string
='('& concat({-<[Date Closed]={*}>} DISTINCT [Call ID], '|')&')'

Resolved:
Select in Field Call ID with search string
='('& concat({<[Date Closed]={*}>} DISTINCT [Call ID], '|')&')'

Unresolved within 30 days:
Select in Field Call ID with search string
='('& concat({-<[Date Closed]={*}, [Date logged]={"$(='<=' & date(today()-30))"}>} DISTINCT [Call ID], '|')&')'

Re: Buttons!

Wed, 14 May 2014 15:45:24 GMT

Hi Michael,

Thanks for your reply but those haven't wrked

Juan Olivares I have used your suggestion and updated my script so that it is calculated in there:-

if([Date logged]+30 < Today(),1,0) AS Days,
If(isNull([Date closed]),1,0) AS Resolved,

So that records are flagged as a 1 if it is more than 30 days and 0 for others.

And then used an Action> Select In Field Days and Search String 1

which seems to work

Thanks everyone!

xXx

Re: Buttons!

jaimeaguilar — Wed, 14 May 2014 18:36:26 GMT

Hi,

besides doing it with flags at script level, you can also set 3 different actions for the buttons:

Unresolved Issues --> select in field > search string --> ='=isnull(CLOSEDATE)'
Resolved Issues --> select in field > search string --> ='=isnull(CLOSEDATE)=0
>= 30 days since log and unresolved --> ='=TODAY() - [LOG DATE] >= 30 AND ISNULL(CLOSEDATE)'

check the attached example,

regards

Re: Buttons!

stevedark — Wed, 14 May 2014 18:41:40 GMT

Hi Natalie,

I have created a document which shows the many and varied things you can do with buttons, or text areas with click Actions. Making selections is just one aspect.

That document can be downloaded here: QlikView App: At The Qlik Of A Button

There is also a blog post with information on how to achieve the things shown in the app, and a video showing it in action.

Hope that is useful to you.

Steve

Re: Buttons!

Thu, 15 May 2014 08:28:30 GMT

Thank you Jaime Aguilar, I have tried that and it has worked

Thanks for the link Steve Dark

Natalie

xXx