Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data not showing Properly in a Straight Table

Hi All,

Please find the attached Qvw where data is not showing properly. I can see two values of some dimensions. Also i have attached the Data Model. As i understood it should be the mistake in datamodel.

Please help me with this.

Regards,

Keerthi KS

9 Replies
sunny_talwar

Working with PE edition of QlikView, would you be able to share some screenshots of the issues at hand

Not applicable
Author

Capture.PNG

settu_periasamy
Master III
Master III

Hi,

Try this,

For the Dimension SAP_Cust_ID, Check Suppress When value is Null

Capture.JPG

Not applicable
Author

If i suppress the values for Milestone, Total received, Total invoice without tax and few other fields will be Zero.

jagan
Luminary Alumni
Luminary Alumni

Hi Keerthi,

Chart Properties -> Dimension-> SAP_Cust_ID -> Select Supress When Value is Null option.

Regards,

Jagan.

Not applicable
Author

There are some measures associated with it. Those values will be empty if i supress

qlikviewwizard
Master II
Master II

Hi keerthiks

Please follow Settu and Jagan solution. It will help you.

Not applicable
Author

Capture.PNG

Total Service tax has some values but if i suppress it will be zero. Is that bcoz there is no mapping between Sapcustomeid ?

qlikviewwizard
Master II
Master II

Hi Keerthi, Yes.