Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Looks like you have a selection on the field Kunde, is that what you wanted?
What is expression you use on textbox to show 43?
count(Lieferscheine)?
If yes, what gives you count(distinct Lieferscheine)?
regards
Darek
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
Hi Wolfgang:
You may have an unwanted selection.
Try pessing the clear button and see if this solves the problem.
Regards
Yes indeed,
and it seems that Jonathan had the right idea,
thanks to all of you!
Wolfgang
Thanks Dariusz,
distinct is always a good idea, however, here Jonathan has obviousely the correct idea!
Wolfgang
Hi Jonathan,
thank you, it Looks like the calculation and NULL - suppressing should work
together as you supposed,
great,
Wolfgang
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 🙂