Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make my pivot only display total amount ?

Hi All

May i know how to make the Table 1 , Now is display all the expense items . i need it display only the total amount , so that i can convert the table into line chart to view trend by month.

Meaning the table only have one row , so that i can change to line chart.

in my next post i will attach the QV Doc.

Paul

5 Replies
paulyeo11
Valued Contributor II

Re: How to make my pivot only display total amount ?

Enclosed my QV Doc

Not applicable

Re: How to make my pivot only display total amount ?

Leave your dimension empty...

Not applicable

Re: How to make my pivot only display total amount ?

Remove

=if(Seq>1 and EXP_P='Y' AND  len(Trim($(ColumnDim8)))>1,$(ColumnDim8) & ' ' )

from dimension

paulyeo11
Valued Contributor II

Re: How to make my pivot only display total amount ?

Hi Vinod

After i remove dimension , it only display 1 row , but the total amount changes , the total amount wrong.

Paul

Not applicable

Re: How to make my pivot only display total amount ?

Hi Paul,

I examined the code and found that your expression is an average, means, you are dividing Amount with $(ColumnDim98). So, when remove the first dimension from the table. it just do the average for the yearmonth but in earlier case it was doing sum

Community Browser