Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

QlikSense table row calculation

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

1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: QlikSense table row calculation

Hi,

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

5 Replies
devarasu07
Honored Contributor II

Re: QlikSense table row calculation

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
Honored Contributor II

Re: QlikSense table row calculation

Hi,

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

Not applicable

Re: QlikSense table row calculation

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
Honored Contributor II

Re: QlikSense table row calculation

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.

Capture.JPG

Hope this helps you

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

Regards,

Deva

Not applicable

Re: QlikSense table row calculation

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