last 3 months using where clause

[#1]

Hello All,

i have 13 months of data . i would like to restrict last 3 months of data for a specific graph in the chart and also i have a graph where i have to show last 12 months of data .

i would like to restrict data in to qlikview by using where clause to restrict last 12 months of data  and 3 months of data at expression for graphs which require trend analysis for 3 months .

[#2]

Hi jagan ,

i am getting an error . while using expression .i have month filed only which  is monthesvd and datesvd but i am getting this function as in image 1 .

.

this is the below expression i am using , can you please help me correct my expression?

[PrashantSangle]

Hi,

Which filter not fixed at first time??

try like

For last 3 months

In set Analysis try like

Count({<Date={">=$(=Date(Addmonths(max(Date),-3)))<=$(=date(max(Date)))"},[dfft_Fix Time]={"Not fixed first time"}>} [Dfft_Enterprise System])

Regards

[renjithpl · Accepted solution]

=count({<Monthesvd=, Date={'>=$(=MonthStart(Today(), -2)) <=$(=Today())'}>} [esvd_Enterprise_System])

missed a close bracket..

[#5]

hi max ,

i am getting last 4 months of data , i even tried changing from -3 to -2 but it is not changing

please check the images .

[PrashantSangle]

Hi,

Debug set analysis by following below steps

1)Covert Chart to straight table.

2)Remove Label of expression and press OK

3)Take your arrow to header of that expression and check the date range it is showing in that expression and modify

the expression as per requirement.

Regards,

[#7]

it is working thanq

[#8]

hi jagan , after using your expression .

i have many month field names in my excel . right now i am using one specific field at WHERE condition , but some graphs which i am using different month field is giving me last 4 months only . both monthfields are similar and have respective months data in it .