Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
=if(fabs(column(1))=0,1,column(2) / fabs(column(1))-1)
Go to Solution.
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
Below is the link of my QV QVW file :-
Dropbox - sales drop percentage wrong.qvw
Without sample app it is hard to match your expected number. Could you post your sample app?
already posted . but need modulator approval before it can post.
Thank you very much for your response.
Enclosed is my QV Doc.
seems document is corrupted. not able to open.
please repost the QVW.