Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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.