topic Re: Double Values Appearing in the view in QlikView

Double Values Appearing in the view

rohitians — Wed, 10 Apr 2013 07:21:17 GMT

Hello,

I am having a straight table where in I am having Vendor master here in I am having details of all the vendors,

but vendor code is repeating how can I avoid this situation...I cannot use suppress null becoz there is condition where in I may miss data so...

I am attaching an excel example.

Thanks and Regards,

Rohit Yadav

Re: Double Values Appearing in the view

swuehl — Wed, 10 Apr 2013 14:33:33 GMT

It seems to me that you are using more fields than necessary as dimensions.

Only use as many dimensions as you need to group your data by. If you want to show additional information to a dimension, use an expression.

So, I would suggest that you only use VendorCode as dimension.

Create expressions for VendorName etc.

Does this make sense?

Re: Double Values Appearing in the view

Wed, 10 Apr 2013 15:16:22 GMT

Hi,

Probably, the problem is in the model, the relations between tha tables, so we need share us the E/R of the model, the sintax of the expressión. If is possible you share us the app, it would be better.

Regards,

Ricardo