Cumulative values without nulls and Regressive cumulative in just one column-Pivot Table

[JD_2024]

Hello All,

I would like to request your assistance to build a Pivot table in Qlik Sense that uses the same logic that was built in the below table. 

I was able to build this.

Please let me know your comments on this!

Thanks.

[brunobertels · Accepted solution]

Hi 

create a crosstable with 

dimension 

Date

Hour 

and another dimension using valuelist fonction 

valuelist('New','Pending','Closed','Archived','Total') 

And a mesure with if statement 

if(

valuelist('New','Pending','Closed','Archived','Total') ='New' , 

mesure for New here , 

if(

valuelist('New','Pending','Closed','Archived','Total') ='Pending' , 

mesure for Pending here ,

if(

valuelist('New','Pending','Closed','Archived','Total') ='Closed' , 

mesure for Closed here ,

if(

valuelist('New','Pending','Closed','Archived','Total') ='Archived' , 

mesure for Archived here ,

if(

valuelist('New','Pending','Closed','Archived','Total') ='Total' , 

mesure for Total here ,

))) ) )

Then for each mesure you may be need to used aggr funciton , set analysis , total identifier and nodistinct identifier . 

Hope it helps 

[JD_2024]

It works! Thanks