Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Pivot table

I have the  pivot table:

DivisionFinMounthRevenues 2017Revenues 2016Cumulative 2017Plan 2017after-admisionChange 16-17
AAAJan148 025 €112 067 €148 025 €158 333 €0 €-10 309€
AAAFeb127 924 €163 539 €275 948 €316 666 €0 €-40 718€
AAAMar19 124 €177 144 €295 072 €475 000 €0 €-179 927€
AAAApr0 €152 992 €0 €633 333 €0 €-633 333€
AAAMáj0 €160 683 €0 €791 666 €0 €-791 666€
AAAJún0 €122 923 €0 €949 999 €0 €-949 999€
AAAJúl0 €107 776 €0 €1 108 332 €0 €-1 108 332€
AAAAug0 €136 230 €0 €1 266 666 €0 €-1 266 666€
AAASep0 €122 494 €0 €1 424 999 €0 €-1 424 999€
AAAOkt0 €151 407 €0 €1 583 332 €0 €-1 583 332€
AAANov0 €144 699 €0 €1 741 665 €0 €-1 741 665€
AAADec0 €190 661 €0 €1 900 000 €0 €-1 900 000€
AAATotal295 072 €1 742 615 €0 €0 €0 €0 €
AAA+Jan10 224 €1 728 €10 224 €21 667 €0 €-11 443€
AAA+Feb130 €43 694 €10 354 €43 333 €0 €-32 979€
AAA+Mar72 €55 574 €10 426 €65 000 €0 €-54 573€
AAA+Apr0 €37 447 €0 €86 666 €0 €-86 666€
AAA+Máj0 €4 265 €0 €108 333 €0 €-108 333€
AAA+Jún0 €27 482 €0 €130 000 €0 €-130 000€
AAA+Júl0 €9 618 €0 €151 666 €0 €-151 666€
AAA+Aug0 €13 637 €0 €173 333 €0 €-173 333€
AAA+Sep0 €6 680 €0 €194 999 €0 €-194 999€
AAA+Okt0 €22 964 €0 €216 666 €0 €-216 666€
AAA+Nov0 €8 566 €0 €238 333 €0 €-238 333€
AAA+Dec0 €24 169 €0 €260 000 €0 €-260 000€
AAA+Total10 426 €255 823 €0 €0 €0 €0 €
BBBJan14 760 €13 926 €14 760 €27 500 €0 €-12 740€
BBBFeb23 272 €11 644 €38 031 €55 000 €0 €-16 969€
BBBMar133 €46 609 €38 164 €82 500 €0 €-44 336€
BBBApr0 €14 436 €0 €110 000 €0 €-110 000€
BBBMáj0 €38 061 €0 €137 500 €0 €-137 500€
BBBJún0 €19 301 €0 €165 000 €0 €-165 000€
BBBJúl0 €24 015 €0 €192 500 €0 €-192 500€
BBBAug0 €32 403 €0 €220 000 €0 €-220 000€
BBBSep0 €13 369 €0 €247 500 €0 €-247 500€
BBBOkt0 €28 393 €0 €275 000 €0 €-275 000€
BBBNov0 €38 400 €0 €302 500 €0 €-302 500€
BBBDec0 €29 964 €0 €330 000 €0 €-330 000€
BBBTotal38 164 €310 521 €0 €0 €0 €0 €

I need to show only values to today´s mounth - so to march. Also I need to insert extra row between divisions - due to lucidity. The result table should be:

       

DivisionFinMounthRevenues 2017Revenues 2016Cumulative 2017Plan 2017after-admisionChange 16-17
AAAJan148 025 €112 067 €148 025 €158 333 €0 €-10 309€
AAAFeb127 924 €163 539 €275 948 €316 666 €0 €-40 718€
AAAMar19 124 €177 144 €295 072 €475 000 €0 €-179 927€
AAATotal295 072 €1 742 615 €0 €0 €0 €0 €
AAA+Jan10 224 €1 728 €10 224 €21 667 €0 €-11 443€
AAA+Feb130 €43 694 €10 354 €43 333 €0 €-32 979€
AAA+Mar72 €55 574 €10 426 €65 000 €0 €-54 573€
AAA+Total10 426 €255 823 €0 €0 €0 €0 €
BBBJan14 760 €13 926 €14 760 €27 500 €0 €-12 740€
BBBFeb23 272 €11 644 €38 031 €55 000 €0 €-16 969€
BBBMar133 €46 609 €38 164 €82 500 €0 €-44 336€
BBBTotal38 164 €310 521 €0 €0 €0 €0 €

Thanks a lot for answer.

4 Replies

Re: Pivot table

in the dimension

if(FinMounth=month(today()),FinMounth)

then check the suppress null in the dimension tab ...

Highlighted
Creator
Creator

Re: Pivot table

it si OK, thank you

Highlighted
Creator
Creator

Re: Pivot table

and extra freerow between divison ? don´t you know ?

Highlighted

Re: Pivot table

We don't have a direct way to achieve that , check this

Insert Blank Lines in Pivot Table

Blank values in Pivot table