Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

logic problem

Hi,

I have storage plant and plant stock two fields

In the year 2014 I have 7 storage plants and when I select 2014 april I have only 4 storage plants and remaining 3 are missing that is Null it is not specifeid in the data base. for the Null values I need to take from the previous Month that contains the value that maybe 0 or anything

For example

2014     plant stock

tab          454    

taj          222    

tam          554    

yrj          878         

tje          986         

fjfs          665

April2014          Plantstock

tab                    88    

taj                    96    

tam                    54

here YRJ TJE and FJFS are missing so i want to search in the previous month for that storageplant has value or not

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Can you post an example document with some data?


talk is cheap, supply exceeds demand