Repeat Dimension in Qliksense Table

[pradnyathakur]

Hi All,

We have a requirement to repeat the dimension values but for 2 different expressions.

Consider we have data in below format

Market	Product	Sales
A	P1	100
A	P2	200
B	P3	300
C	P4	400

Now, we need the output in below format :

Market	Sales
A	100
A	200
B	300
C	400

So even though the Product dimension is not there in table we want to repeat the values for Product.

Is there any way we can achieve this functionality in QlikSense table.

Thanks in Advance !

[Lisa_P]

If you add a table with Market and Sales as dimensions this should work

[pradnyathakur]

Hi Lisa,

We need sum(Sales) as a metric. and if we include this it shows only 1 row for each market

[raman_rastogi]

If you want to use sum(Sales) as a expression then you have to add Product as dimension in your table or you can add sales as dimension in your table. As per my knowledge there is no other way to achieve this.

Sum() calculates the total of the values given by the expression or field across the aggregated data.

Regards

Raman