Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

last 3 months using where clause


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 .

16 Replies
Not applicable
Author


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 .

Capture2.PNG.

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

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
renjithpl
Specialist
Specialist

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

missed a close bracket..

Not applicable
Author

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 .Capture2.PNGCapture1.PNG

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author


it is working thanq

Not applicable
Author

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 .