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: 
RK01923683
Contributor II
Contributor II

Fetch today and last year data

Hi Experts, 

I am New to qlik sense. Need Help

I have to Fetch two dates data at the same time one is Today and other one is any date from last year.  The timing of the data for both the dates should be until today's current time after each data load.

For Example: 

Today is 6 june 2021 and time is 4:30 at the time of loading data the data for both the dates should be util 4:30

Sample---- Data Load  at 4:30 Today

The result table should be like this

-------------------------------------------------------------------|---------------------------------------------------------------------------------------

Current Day Data 6 june 2021 4:30 PM                                              1 February 2020 4:30 PM 

Total Transactions      80                                                                         Total Transaction  30

-------------------------------------------------------------------|----------------------------------------------------------------------

Locations                    Transactions                                                                 Loactions                           Transactions

Loaction 1                     50                                                                                      Loaction 1                                       10

Location2                       30                                                                                 Location 2                                           20

------------------------------------------------------------------------------------------------------------------------------------------

I hope you guys get it

Thanks

Any suggestion would be very helpful

 

Labels (3)
0 Replies