Custom Object

[Dolly123]

I want 3 buttons from custom object like last 3 month ,last 6 month , last 12 months

I was created the variable 1 

how to implement 

bar chart and piechart also change when we will click the 3 month it will chges accordingly , 6 month chart should chg 

any one know ?

[ogster1974]

to get what you want i've used 2 variables.

1. vMonths to set the month parameter. default 3

2. vLastXMonths to perform your measure calculation. =AddMonths(Max([Order Date]),-$(vMonths))

3. Created a master measure sum({<[Order Date]={'>$(vLastXMonths)'}>} Sales)

4. Created 3 buttons labelled to each parameter and then set it to change vMonths accordingly either 3,6,12.

5.  Applied master measure into my charts.

See below

[Dolly123]

I dont have button because older version of Qliksense i have to work with custom objects variable

[ogster1974]

If you're referring to the QSVariable extension then you can make it look like a button and set a variable value in it just like the current button.

[Dolly123]

Point no 1 by default 3 

what does it mean 

I didn’t get this 

[ogster1974]

It means whilst I created the variable vMonths I set its value to 3.

[Dolly123]

Why 3 we are setting the value for 3 buttons to 3 ?

[ogster1974]

You aren't   the buttons would set the variable to 3, 6 and 12 respectively.

[Dolly123]

could u please send me your linkdn profile link 

[Dolly123]

i am creating variable set value 3