Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Micki
Creator
Creator

Duplicate rows in dimension straight table (chart)

Hi, does it possible to duplicate rows in dimension (without do it in load statement) using expression? 

Current table 

Micki_0-1600936106535.png

Desired output:

Micki_1-1600936299864.png

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

@Micki  One solution is to add a dimension in your table

the dimension to add is :

=valueloop (1,2)

if you want you can use white for value and title to make it invisible to users

befor colore the output like :

Capture.PNG

after color

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Taoufiq_Zarra

@Micki  One solution is to add a dimension in your table

the dimension to add is :

=valueloop (1,2)

if you want you can use white for value and title to make it invisible to users

befor colore the output like :

Capture.PNG

after color

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post