topic Different values in each table box in QlikView

Different values in each table box

ashishpalkar — Tue, 16 Jun 2015 18:12:59 GMT

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.

Re: Different values in each table box

maxgro — Tue, 16 Jun 2015 18:20:30 GMT

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')

Re: Different values in each table box

ashishpalkar — Tue, 16 Jun 2015 18:27:04 GMT

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 Caption	Text B Caption	Text C Caption	Text D Caption
Value XYZ	Value qwqw	Value asdasd	Value adad

Text E Caption	Text F Caption	Text G Caption	Text H Caption
Value ass	Value qwq	Value asaas	Value adada

Re: Different values in each table box

maxgro — Tue, 16 Jun 2015 18:38:56 GMT

and this is my idea (PFA)