topic Re: Cumulative values without nulls and Regressive cumulative in just one column-Pivot Table in App Development

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

JD_2024 — Thu, 08 Feb 2024 10:10:18 GMT

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 — Thu, 08 Feb 2024 11:25:31 GMT

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 — Thu, 08 Feb 2024 12:30:42 GMT

It works! Thanks