Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator III
Creator III

Generate data for previous month if current month data not available

Hi Team,

 

I have a dataset in which i have   a feild called ID whose value is coming from the database

 

Suppose i have refreshed the data for the month of jan

Now, if the i have the data for the month of Jan in backend, so the value of ID will be 0 and it will show that data is updated.

 

However, if there  is no data in the database for the month of Jan, it should show the data for the month of Dec and the value of ID will be 1 stating that the data is not updated.

 

How should i show the data for the month of december when we don't have january data in the database using loops.

 

Please help.

 

Thanks is advance.

 

0 Replies