Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
sivakrishna
Contributor II
Contributor II

How to get difference of accumulated values over two dimensions

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.

 

Labels (2)
1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

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;

View solution in original post

1 Reply
lorenzoconforti
Specialist II
Specialist II

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;