topic Re: One Field Taking Others Field Data in QlikView

One Field Taking Others Field Data

Thu, 20 Sep 2012 18:24:33 GMT

I have Sales field and Bill field,

when I am taking a chart with dimension as year and expression as Sum(sales), the sales bar is showing the data same as Bill field data, can you suggest me, where might be the problem

Re: One Field Taking Others Field Data

MayilVahanan — Thu, 20 Sep 2012 18:35:51 GMT

Did you check the table viewer, whether there is a link between year and bill field data?

Re: One Field Taking Others Field Data

Thu, 20 Sep 2012 19:29:07 GMT

Yes Samy,Bill and year are in the same table only,I am not getting the exact data of the sales year wise

Re: One Field Taking Others Field Data

MayilVahanan — Thu, 20 Sep 2012 19:41:41 GMT

can you please post a sample file?

Re: One Field Taking Others Field Data

Thu, 20 Sep 2012 20:22:14 GMT

I am posting sample file , in which I have created the sum(sales) year wise charts and gauge charts and also

sum(bill) year wise...you please correct me

thanks,

rams

Re: One Field Taking Others Field Data

MayilVahanan — Thu, 20 Sep 2012 20:41:56 GMT

I can't able to find the error in it..

Please see the attached file,,

Re: One Field Taking Others Field Data

Thu, 20 Sep 2012 21:19:21 GMT

Hi ramasamy ,it is giving same problem..can

Re: One Field Taking Others Field Data

MayilVahanan — Thu, 20 Sep 2012 21:27:52 GMT

In the attached image, can you able to view different value for sum(sales) and sum(bill) in year wise.. If its not , can you please say in detail

Re: One Field Taking Others Field Data

Thu, 20 Sep 2012 21:42:56 GMT

Yes, the values of the sum(sales) and bills are different for both expressions.The sales field is giving is different data when when year is taken as dimension in my friend system.can you say the reason...

Re: One Field Taking Others Field Data

MayilVahanan — Thu, 20 Sep 2012 21:57:05 GMT

I think, there may be any mistake in script or something else.. Check like this , in table box,use year , sales fields and export it in both system. and find any data missing.. or check once the expression also in charts

Re: One Field Taking Others Field Data

Thu, 20 Sep 2012 22:44:34 GMT

will you please link my data model once ,if I send the qvd files,I have done all the sheets ,it seems my data model might be wrong, shall I send mail to your mailid

regard

rams

Re: One Field Taking Others Field Data

MayilVahanan — Fri, 21 Sep 2012 14:45:25 GMT

Post in community itself , its better to find the solution easily by anyone in particular time as you want.