Pivot Differences

[Anonymous]

Hi Qlikers,

in General, it works very well. However, after having created a simple PIVOT, I had to notice that this report
does not Show what it should Show.

Whereas there should be 43 items the PIVOT List does only Show up 13.

All 43 items are just the same, there is no Special specification or anything unusual on the remaining 30.
Any idea from the PIVOT Specialists??

Tks

Wolfgang

.. see attached

[jerem1234]

Looks like you have a selection on the field Kunde, is that what you wanted?

[#3]

What is expression you use on textbox to show 43?

count(Lieferscheine)?

If yes, what gives you count(distinct Lieferscheine)?

regards

Darek

[jonathandienst]

Hi

If you clear the selection?

Suppressing zeros and nulls perhaps, or an incomplete association between tables (if the expressions and dimensions span more than one table)?

HTH

Jonathan

[cfz]

Hi Wolfgang:

You may have an unwanted  selection.

Try pessing the clear button and see if this solves the problem.

Regards

[Anonymous]

Yes indeed,
and it seems that Jonathan had the right idea,
thanks to all of you!

Wolfgang

[Anonymous]

Thanks Dariusz,
distinct is always a good idea, however, here Jonathan has obviousely the correct idea!

Wolfgang

[Anonymous]

Hi Jonathan,

thank you, it Looks like the calculation and NULL - suppressing should work
together as you supposed,

great,

Wolfgang

[Anonymous]

Hi Carlos,

thanks your Input! NULL suppressing was the answer, obviousely.

Wolfgang

... but it is always very important to have an eye on the selection  🙂