Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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...

Highlighted
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