Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rocky6
Creator
Creator

Retrieve last month values from table through script

Hi All 

I have a table  where it has data for last 6 months . I need data which has last month data only.

for example i have 10 values in may month and 10 values in June month . 

I need to get only June month values as 10 from the table. 

Can anyone help me out how to bring that values from load script. 

The field name used in the table is monthly refresh

 

Labels (8)
1 Reply
Lokesh_5045
Creator
Creator

First load the date field and store the max month into a variable vMaxMonth.

Then load the data for that month only.

Data:
Load
----
----
From -----
where Month = '$(vMaxMonth)'