buttons

[#1]

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

[amit_saini]

Siva,

Check this:

6 months data, 1 year Data and FROM to TO

Thanks,

AS

[PrashantSangle]

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

[sujeetsingh]

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.

[jagan]

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.

[ngulliver]

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