topic Re: buttons in QlikView

buttons

Thu, 27 Nov 2014 06:24:21 GMT

see i want three buttons in a document. and if i clicks first buttons.it should displays the last six months data i.e sum of sales on chart.

if i clicks second button it should displays last 3 months data and if i clicks third button it should displays last 2 months?. can any body solve this problem????

Re: buttons

amit_saini — Thu, 27 Nov 2014 06:29:37 GMT

Siva,

Check this:

6 months data, 1 year Data and FROM to TO

Thanks,

Re: buttons

PrashantSangle — Thu, 27 Nov 2014 06:31:01 GMT

Hi,

There are various way to solve this issue.

1 st way

Create 3 different chart and use Hide/Show each report on button click.

2nd way

Create variable in that set value for that variable

then use that variable in your set analysis through which you are generateing Sales

Regards

Re: buttons

sujeetsingh — Thu, 27 Nov 2014 06:34:03 GMT

Amit has provided you the link for the one you need.

You can first know the setting for Dimension limits and then move on for the variables and pass them there.

Re: buttons

jagan — Thu, 27 Nov 2014 06:36:29 GMT

Hi,

Try like this

Set variable value as 6 for 6 months, 3 for 3 Months and 2 for 2 months buttons and use single chart

Assume that variable name is vPeriodOfMonths

=Sum({<Date={'>=$(=MonthStart(Max(Date), -vPeriodOfMonths))<=$(=MonthEnd(Max(Date)))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: buttons

ngulliver — Sun, 21 Dec 2014 18:09:30 GMT

Hi, Siva.

Have a look at this blog on buttons it is a useful guide and has working examples.

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

Regards,

Neil