topic Re: Merging two charts total in QlikView

Merging two charts total

NavinReddy — Tue, 17 Dec 2019 19:32:25 GMT

Hello All,

i have two chart with the total information, for each number i have one expression.i need to calculate the total % on weekly basis. kindly help me

Expected Output

Now i need to merge these two charts to calculate the %,
could some one help me with the logic.

Thanks in Advance

Navin

Lisa_P — Tue, 17 Dec 2019 21:50:43 GMT

Create the output table, the other tables should be linked through the Issue Names field in the data model.

Simply create the first 3 columns as dimensions, then in the last column create the expression:

([Current Week Total]-[Prior Week Total])/[Prior Week Total] and label it as WoW % Change, format the result as an integer, Show in Percent

NavinReddy — Wed, 18 Dec 2019 12:17:51 GMT

@Lisa_P thanks for your reply

Im bit confused implement this logic, do you want me to create output table in script side. Suggest me