Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Different values in each table box

Hi There

I want to add a table with fixed columns and rows. However each box in that table is independent record (individual dimension). Each dimension has single record associated with it.

Can we achieve this and how?

This will help me to avoid adding multiple text boxes for each dimension.

Thanks in advance. 

3 Replies
maxgro
MVP
MVP

if I understand, in a straight table

calculated dimension

valuelist(1,2,3)

expression (replace exp1/2/3 with your expression)

pick(

  match(

  valuelist(1,2,3)

  ,1,2,3),

'exp 1', 'exp 2', 'exp 3')

ashishpalkar
Creator III
Creator III
Author

Lets take below example, i have dimensions A to H. I have to create 8 text boxes which i want to avoid by creating single table.

  

Text A CaptionText B CaptionText C CaptionText D Caption
Value XYZValue qwqwValue asdasdValue adad

Text E CaptionText F CaptionText G CaptionText H Caption
Value assValue qwqValue asaasValue adada
maxgro
MVP
MVP

and this is my idea (PFA)

1.png