QlikSense table row calculation

[#1]

Hi,

Can I create table like following sample?  Third row has Expression = (row2-row1) / row 1

It's easy to do this in column. How do I do it in row?

My dimension is Year. Each column is the measure of the type.

Thanks

Regards

I-Cheng

[devarasu07]

Hi,

Yea it can be done.

Just use like below,

(Column(2)-Column(1))/Column(1)

or

create two calculated dimensions as 2016 and 2017 then

=((cal.dim2016) - (cal.dim2017))/ (cal.dim2017))

Hope this helps you

Regards,

Deva

[devarasu07 · Accepted solution]

Hi,

Please refer to attached sample mock. let me know if still not working.

[#4]

Hi Deva,

Thanks a lot for the tip. The Dimensionality() function for the scenario is a neat approach.

Do you know if there's way we can set the '(%)Change' in the bottom? For straight table you can specify "Total" position. I can't find corresponding attribute in Pivot table.

Thanks

Regards

I-Cheng

[devarasu07]

Hi,,

Yeah both table & pivot table can be done, please refer to the attachment.

using table view u can put the total in bottom of u r report (u need to paste u r expression under presentation tab --> Total field (refer below screen shot).

note: pivot table we can't put the total in below  (there tool default chart limitation).

i would suggest you go for Pivot table option.

Hope this helps you

if your issue resolved, help to close this thread by marking correct/helpful. Tks

Regards,

Deva

[#6]

Hi Deva,

Appreciate your help! Pivot table is more close to what I need to present.

I am unable to use straight table to make "Total" work. I have more than one measures and each with different criteria.

Although straight table can show "Total" in bottom.

Thanks a lot!

Regards

I-Cheng