This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
in General, it works very well. However, after having created a simple PIVOT, I had to notice that this reportdoes 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??
.. 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?
If yes, what gives you count(distinct Lieferscheine)?
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)?
You may have an unwanted selection.
Try pessing the clear button and see if this solves the problem.
Yes indeed,and it seems that Jonathan had the right idea,thanks to all of you!
Thanks Dariusz,distinct is always a good idea, however, here Jonathan has obviousely the correct idea!
thank you, it Looks like the calculation and NULL - suppressing should worktogether as you supposed,
thanks your Input! NULL suppressing was the answer, obviousely.
... but it is always very important to have an eye on the selection 🙂