topic Re: Pivot Differences in QlikView https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637606#M233815 <HTML><HEAD></HEAD><BODY><P>Hi Wolfgang:</P><P>You may have an unwanted&nbsp; selection.</P><P>Try pessing the clear button and see if this solves the problem.</P><P>Regards</P></BODY></HTML> Tue, 03 Jun 2014 13:32:13 GMT cfz 2014-06-03T13:32:13Z Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637602#M233811 <HTML><HEAD></HEAD><BODY><P>Hi Qlikers,</P><P>in General, it works very well. However, after having created a simple PIVOT, I had to notice that this report<BR />does not Show what it should Show.</P><P>Whereas there should be 43 items the PIVOT List does only Show up 13.</P><P>All 43 items are just the same, there is no Special specification or anything unusual on the remaining 30.<BR />Any idea from the PIVOT Specialists??</P><P>Tks</P><P>Wolfgang</P><P></P><P>.. see attached</P></BODY></HTML> Tue, 03 Jun 2014 13:23:31 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637602#M233811 Anonymous 2014-06-03T13:23:31Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637603#M233812 <HTML><HEAD></HEAD><BODY><P>Looks like you have a selection on the field Kunde, is that what you wanted?</P></BODY></HTML> Tue, 03 Jun 2014 13:28:05 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637603#M233812 jerem1234 2014-06-03T13:28:05Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637604#M233813 <HTML><HEAD></HEAD><BODY><P>What is expression you use on textbox to show 43?</P><P>count(Lieferscheine)?</P><P>If yes, what gives you count(distinct Lieferscheine)?</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Tue, 03 Jun 2014 13:29:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637604#M233813 2014-06-03T13:29:13Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637605#M233814 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hi</SPAN></P><P></P><P>If you clear the selection?</P><P></P><P>Suppressing zeros and nulls perhaps, or an incomplete association between tables (if the expressions and dimensions span more than one table)?</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Tue, 03 Jun 2014 13:30:26 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637605#M233814 jonathandienst 2014-06-03T13:30:26Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637606#M233815 <HTML><HEAD></HEAD><BODY><P>Hi Wolfgang:</P><P>You may have an unwanted&nbsp; selection.</P><P>Try pessing the clear button and see if this solves the problem.</P><P>Regards</P></BODY></HTML> Tue, 03 Jun 2014 13:32:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637606#M233815 cfz 2014-06-03T13:32:13Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637607#M233816 <HTML><HEAD></HEAD><BODY><P>Yes indeed,<BR />and it seems that Jonathan had the right idea,<BR />thanks to all of you!</P><P>Wolfgang</P></BODY></HTML> Tue, 03 Jun 2014 14:07:02 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637607#M233816 Anonymous 2014-06-03T14:07:02Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637608#M233817 <HTML><HEAD></HEAD><BODY><P>Thanks Dariusz,<BR />distinct is always a good idea, however, here Jonathan has obviousely the correct idea!</P><P>Wolfgang</P></BODY></HTML> Tue, 03 Jun 2014 14:08:20 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637608#M233817 Anonymous 2014-06-03T14:08:20Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637609#M233818 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan,</P><P>thank you, it Looks like the calculation and NULL - suppressing should work<BR />together as you supposed,</P><P>great,</P><P>Wolfgang</P></BODY></HTML> Tue, 03 Jun 2014 14:09:34 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637609#M233818 Anonymous 2014-06-03T14:09:34Z Re: Pivot Differences https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637610#M233819 <HTML><HEAD></HEAD><BODY><P>Hi Carlos,</P><P>thanks your Input! NULL suppressing was the answer, obviousely.</P><P>Wolfgang</P><P></P><P></P><P>... but it is always very important to have an eye on the selection&nbsp; <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 03 Jun 2014 14:10:40 GMT https://community.qlik.com/t5/QlikView/Pivot-Differences/m-p/637610#M233819 Anonymous 2014-06-03T14:10:40Z