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: 
subbareddykm
Creator II
Creator II

Issue

Hi all,

I m working one query but not able to achieve it.

What is want in final result is i have to create calender for this using min data and max data using this data (I have created it) and for some months we do not have any data for  it.

in that case i have show previous month data.

For example:

Case 1 :I have data for Jan 2016 and Next i dont have data for Feb 2016 so if click on Feb 2016 i wan to Pick data for Jan 2016.

Case 2: If i have data Jan 2016 and Nxt if doesn't have data Fab 2016 , Mar 2017 and i have data Apr 2016. i this case i don't have data for two month i.e. Feb and Mar so If i click on Feb 2016 It should show me Jan 2016 and Also if click on Mar 2016 It should show me Jan 2016 bcoz in actual data Only avalilable for Jan 2016.

I hop you understood.

please help me on this.

1 Solution

Accepted Solutions
ElizaF
Creator II
Creator II

Hi,

You can use AsOfPeriod concept.

See attached file.

Hope this helps.

View solution in original post

3 Replies
subbareddykm
Creator II
Creator II
Author

Anyone have idea to achieve this?

subbareddykm
Creator II
Creator II
Author

Please help someone on this

ElizaF
Creator II
Creator II

Hi,

You can use AsOfPeriod concept.

See attached file.

Hope this helps.