topic Re: Need to create a straight table in QlikView

Need to create a straight table

qlikapple — Sat, 16 Nov 2024 01:31:37 GMT

I have requirement below. I need to create a table based on the excel data, I have given the requirement in the excel .

can anyone please help

Lisa_P — Mon, 13 Jan 2020 23:51:08 GMT

To get the output you need a pivot table to do the grouping.

Product and Month as Dimensions.

Sum(Refered) as Expression and sum(Refreerd%) as Expression.

Expand Product column. Sort Month by load order.

Brett_Bleess — Tue, 11 Feb 2020 21:23:32 GMT

In addition to what Lisa gave you, the following Design Blog may prove helpful too:

Here is the base URL if you want to do some further searching on your own there, there are over 700 posts from our experts and most are how-to based.

Regards,
Brett