topic Re: Data not showing Properly in a Straight Table in QlikView

Data not showing Properly in a Straight Table

Wed, 12 Aug 2015 04:36:32 GMT

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

Re: Data not showing Properly in a Straight Table

sunny_talwar — Wed, 12 Aug 2015 04:50:41 GMT

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

Re: Data not showing Properly in a Straight Table

Wed, 12 Aug 2015 04:54:41 GMT

Re: Data not showing Properly in a Straight Table

settu_periasamy — Wed, 12 Aug 2015 05:29:25 GMT

Hi,

Try this,

For the Dimension SAP_Cust_ID, Check Suppress When value is Null

Re: Data not showing Properly in a Straight Table

Wed, 12 Aug 2015 05:37:53 GMT

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

Re: Data not showing Properly in a Straight Table

jagan — Wed, 12 Aug 2015 05:42:18 GMT

Hi Keerthi,

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

Regards,

Jagan.

Re: Data not showing Properly in a Straight Table

Wed, 12 Aug 2015 05:44:21 GMT

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

Re: Data not showing Properly in a Straight Table

qlikviewwizard — Wed, 12 Aug 2015 06:03:18 GMT

Hi keerthiks

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

Re: Data not showing Properly in a Straight Table

Wed, 12 Aug 2015 06:07:23 GMT

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

Re: Data not showing Properly in a Straight Table

qlikviewwizard — Wed, 12 Aug 2015 06:25:12 GMT

Hi Keerthi, Yes.