Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BhaminiParmar12
Contributor III
Contributor III
‎2024-07-04 05:10 AM

Please Help me with my Below requirement

Hi Everyone, There is a requirement, adding a KPI with last data reloaded KPI vs new Data reloaded KPI , For Example - Latest Reloaded KPI is - 566,833 and if we refresh KPI changed to 600,600 it should give both last reloaded vs new reloaded KPI

Preview file
110 KB
231 Views
0 Likes
1 Reply
shyambutani
Contributor II
Contributor II
‎2024-07-04 07:05 AM

Hello Bhamini,

For this you will have to store the data as a snapshot. Below are the steps:

1. Add a store statement in the script to store the data in QVD.

2. Add logic to read the data from this QVD in the script. So, Now in the data model will have current reloads data as well as previous reloads data. 

3. You can use this in front end to design your KPI or visualization. 

Keep in mind the granularity of the data you want to store. 

 

Thanks,

Shyam

193 Views
0 Likes