Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am new one to qliksense now i am trying to building the dashboard by using corona data,
please let me know the 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;
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;