How to get difference of accumulated values over two dimensions

[sivakrishna]

Hi, I am new one to qliksense now i am trying to building the dashboard by using corona data,

1. In Table Each Day have separate Column, so i have used Crosstable function. But Columns are increasing daily so how can we add newly appended fields to script automatically
2. Values are Accumulated form over dimensions date and country,  how can i get day wise cases of each country in back-end

Data from :https://www.kaggle.com/sudalairajkumar/novel-corona-virus-2019-dataset#time_series_covid_19_confirme...

please  let me know the solution.

[lorenzoconforti · Accepted solution]

This would work for the file "time_series_covid_19_deaths.csv"

Data_temp:
CrossTable(Date, Deaths, 4)
LOAD * FROM [lib://Data/time_series_covid_19_deaths.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Data:
NoConcatenate Load *,
if(Previous([Country/Region])=[Country/Region], Deaths-Previous(Deaths),Deaths) as NewDeaths,
MakeDate(2020,SubField(Date,'/',1), SubField(Date,'/',2)) as DateFixed Resident Data_temp;

Drop table Data_temp;