Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to make my % row display 51% instead of 77% ?

Hi All

I have a straight table . the first row summary % display wrong value. How to make it display 51 % ? if i set the total mode = Average , it display 77% also wrong.

Expression :-

=if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1)

1 Solution

Accepted Solutions
Not applicable

Re: How to make my % row display 51% instead of 77% ?

Hi Sir , As i try to prepare for the the new QV Doc , i found out that my QV doc is working fine now , hank u for your he,p

6 Replies
Not applicable

Re: How to make my % row display 51% instead of 77% ?

Hi All

Below is the link of my QV QVW file :-

Dropbox - sales drop percentage wrong.qvw

MVP
MVP

Re: How to make my % row display 51% instead of 77% ?

Without sample app it is hard to match your expected number. Could you post your sample app?

Not applicable

Re: How to make my % row display 51% instead of 77% ?

Hi tre

already posted . but need modulator approval before it can post.

Paul

Not applicable

Re: Re: How to make my % row display 51% instead of 77% ?

Hi tres

Thank you very much for your response.

Enclosed is my QV Doc.

Paul

phaneendra_kunc
Valued Contributor III

Re: How to make my % row display 51% instead of 77% ?

seems document is corrupted. not able to open.

please repost the QVW.

Not applicable

Re: How to make my % row display 51% instead of 77% ?

Hi Sir , As i try to prepare for the the new QV Doc , i found out that my QV doc is working fine now , hank u for your he,p

Community Browser