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]

if you've done what I've said it should be doing that already.

[Dolly123]

seee this write set for last 3 month in set and then chart should chnages

[Dolly123]

chart is not changing but only create 1 master measure but i need last 3month , last 6month , last 12month ,

[ogster1974]

You only need one master measure not 3.  it should be dynamically changing the set analysis based on the buttons  your using to set the month variable.

[Dolly123]

i create one measure only but not working on charts

[Dolly123]

[ogster1974]

Add the following label into your master measure ='sales (last ' & $(vMonths) & ' months)

create a table chart with your measure and date dimension and troubleshoot your buttons are working correctly.

you should see at least the label changing as you set them to 3,6 and 12 months respectively.

[Dolly123]

I want to write the set analysi for last 3 month , last 6 months , lst 12 months where to write

[ogster1974]

Removing the variables from the solution and hard coding the measures the set analysis looks like this.

sum({<[Order Date]={">$(=AddMonths(Max([Order Date]),-3))"}>} Sales)

sum({<[Order Date]={">$(=AddMonths(Max([Order Date]),-6))"}>} Sales)

sum({<[Order Date]={">$(=AddMonths(Max([Order Date]),-12))"}>} Sales)

[Dolly123]

See i add 3 button like last 3 month , last 6 month , last 12 month 

when user click button 3 month so

peichart & bar chart should change according to select the button

so in my qliksense older so they dont have buttom option

so i was making taking custom objects variable i creating like button now u get it