Table visualization value

[delbooth]

Hi.

I have a table visualization in qlik sense.  Is the re a way to set a specific value in a part of the table.  For example if I have a 2 column table.  Can I set the 1 st value in column 2 to 20 for example (column(2), row (1)=20) and the the rest of the column values are calculated ?

Thanks

[agigliotti]

could you make an example of what are you trying to achieve?

[delbooth]

Hi.

What i want to achieve is this:

Column 1 Row 1 set to 10

Column 2 row 2,3,4 a calculated value eg: Column 2 row 2 is (Column 1 row 1 +Column 2 row 2) or 10 +5

Column 2 taken from data source - I can do this already

  Thanks

Column 1	Column 2
10	5
15	10
25	5
30	5

[bwisealiahmad]

Hi,

Not sure if I entierly understood, but I'll try. You can refer to the columns simply by referring column using column().

So

Column 1          Column 2

10                    =column(1)+5

15                    =column(1)+15

25                    =column(1)+Sum(Expression)

etc.

Is that what you mean?

Best,

Ali A

[delbooth]

Thanks Ali.

The value 10 in bold and underlined I want to set to 10 whilst all other values are read from data or calculated

Cheers

Column 1	Column 2
10	5
15	10
25	5
30	5

[shraddha_g]

Try,

if(rowno()=1,'20', Expression)

[bwisealiahmad]

Hi,

I would solve it in the script then.

Where will you enter the 10 value? In a document or do you want it to be dynamic or always set to 10?

Best,

Ali A