topic Re: Quick Buttons in QlikView

Quick Buttons

Mahamed_Qlik — Wed, 16 Dec 2015 08:55:52 GMT

Hi All,

I Need Quick buttons on my app named as MTD, LMTD.and

I need action on these buttions as when i click on then all the documents data should be as per button.

Exxample if i click on MTD then all the objects on sheet show as per month till date data only.

If I click on LMTD then all the data on sheet should show only data for last month.

Kindly help

Regards,

Mahamed.

Re: Quick Buttons

Wed, 16 Dec 2015 09:01:02 GMT

You can use the show hide conditional show on the buttons.

Place the two text objects one on the other and conditional show them on click of the buttons.

You can refer : Hide/show an Object with button set variable

Regards,

Anjali Gupta

Re: Quick Buttons

Anonymous — Wed, 16 Dec 2015 09:09:38 GMT

Hi,

Refer the below link:

http://www.quickintelligence.co.uk/qlikview-buttons/

Regards,

Bhavini Mehta

Re: Quick Buttons

Anonymous — Wed, 16 Dec 2015 09:13:03 GMT

Hi,

You can also use pick, match in expression..

Re: Quick Buttons

Mahamed_Qlik — Wed, 16 Dec 2015 09:37:02 GMT

Dear Anajali,

Apprciated for your quick response.

But, I m looking for show and hide object schinario.

What i need suppose if i Click on MTD Button then whatever the objects on the sheet, it must show the MTD daata only.

If there is chart then it should show the MTD data in chart as well etc.

Re: Quick Buttons

Wed, 16 Dec 2015 10:04:40 GMT

Hi,

For text objects, you can place one for MTD and second for LMTD.

Create a variable 'vLMTD' and set it with some value, say 0 for MTD or 1 for LMTD.

on the text object properties Caption there is an option for conditional show, write vLMTD=0 on the text object with MTD expression.

and vLMTD=1 on the text object with LMTD expression.

Whereas for charts you can create two expressions and put the same conditions in conditional portion of the same.

Regards,

Anjali Gupta

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 05:52:33 GMT

Dear Bhavini,

Thank you for your kind response.

But I am not looking for any kind of button action activity.

Re: Quick Buttons

Thu, 17 Dec 2015 06:00:48 GMT

Hi Mahamed,

There are couple of ways to achieve this.

1) Create a variable for date start and end and use those in the expression. for example if you click on MTD then min date and max date will set as month start and current date. Use those variables in set analysis of the expression.

2) Create an action in the button as to select the particular date interval.

Let me know if you need any information.

Thanks

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 06:04:12 GMT

Hey Sampath,

Can you please give me more detail on how to achieve second option?

I think that will be more helpful and easiest way of doing.

Re: Quick Buttons

Thu, 17 Dec 2015 06:24:38 GMT

Check out the atachement

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 06:41:32 GMT

No Attachement

Re: Quick Buttons

Thu, 17 Dec 2015 06:54:21 GMT

i am able to see it.

Any how added it again

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 07:03:59 GMT

Still cant see tht.

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 07:26:33 GMT

Dear Bhavini,

Suppose I have Three buttons on top names as "MTD","LMTD","YesterDay".

And I am having multiple filters on sheet.

Filter1, Filter2,Filter3...in differect objects..either list box, multi box, charts ..etc

If I select any of the button, then the filter automatically filters out as per requirement.

for example-

I have "Invoice Date" filter on sheet named as Invoice date.

By default the Invoice Date is showing from Jan-2010 to Dec-2015 and respective data in all other objects present on sheet.

And, I want that, if click on button MTD then this Invoice date filter should filtered out to Dec-2015 dates only and respective data in all other objects.

This is just an single filter on invoice date list object as such i have many objects on the sheet.

Hope this time you get it. and help me out.

Regards,

Mahamed.

Re: Quick Buttons

Mahamed_Qlik — Thu, 17 Dec 2015 07:57:40 GMT

Hi Anjali,

Can you please help with the following requirment :

I have

I need :

Re: Quick Buttons

Sun, 27 Dec 2015 10:47:15 GMT

Click on the chart. Then press ctrl+Shift and drag the legends.

Re: Quick Buttons

Mahamed_Qlik — Tue, 29 Dec 2015 07:46:36 GMT

Thank you for your help.

I will need one more help if you can ,

I am facing below problem in my application :

The bubbles in the chart are not reflecting as per the actual longitude and latitude provided from the database.

Example :

If I select Hong Cong City then the actual longitude and latitude are different and while reflecting on the chart those are different,Also the location of the bubble is showing below the Africa region as the county is China.

Below are screenshot :

Kindly Help.

Regards,

Mahamed.