Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
wolfgangmohr
Contributor III
Contributor III

Pivot Differences

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

8 Replies
jerem1234
Specialist II
Specialist II

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

Not applicable

What is expression you use on textbox to show 43?

count(Lieferscheine)?

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

regards

Darek

jonathandienst
Partner
Partner

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
cfz
Employee
Employee

Hi Wolfgang:

You may have an unwanted  selection.

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

Regards

wolfgangmohr
Contributor III
Contributor III
Author

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

Wolfgang

wolfgangmohr
Contributor III
Contributor III
Author

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

Wolfgang

wolfgangmohr
Contributor III
Contributor III
Author

Hi Jonathan,

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

great,

Wolfgang

wolfgangmohr
Contributor III
Contributor III
Author

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  🙂