topic Re: Aplication is displaying worng values in QlikView

Aplication is displaying worng values

Thu, 15 Mar 2012 07:55:38 GMT

Hi All,

I am facing some wieard problem in my application,

Aplication is displaying worng values

eliran — Thu, 15 Mar 2012 08:01:39 GMT

Hi,

Care to elaborate more?

Re: Aplication is displaying worng values

Thu, 15 Mar 2012 08:40:11 GMT

Hi All,

I am facing some wieard problem in my application, i have attachecd both my application and the pic of excel (only for one country as i cant give the whole file) in the application the table values are incorrect when compared to excel, can any one let me know why is this happening, where i am doing wrong,

Aplication is displaying worng values

Thu, 15 Mar 2012 08:52:20 GMT

Any Help will be appreciated, its a bit urgent becoz there are around 35 chart and in all its taking wrong values, jst 2 day's back whn i have created it, all the values were correct, but whn i opened the file now the values got changes and few of the values in table and chart are wrong, can any one let me know why is it happening,

Aplication is displaying worng values

jvitantonio — Thu, 15 Mar 2012 09:11:40 GMT

Hi, I see all values matching. I need you to do the following. Your sample application is very messy. DELETE everything, and put just a table with what you need to compare and tell us exacatly what to compare it in your excel file (highlight in your excel what we need to be looking at)

Re: Aplication is displaying worng values

Thu, 15 Mar 2012 10:11:22 GMT

hi,

As you see in my application the MAT'10 and MAT'11 values which are highlited in red in the pic is not matching, but the percentage is comming correct, i just want to display the correct values,

Re: Aplication is displaying worng values

Thu, 15 Mar 2012 10:24:12 GMT

Sorry cant able to upload the new report, the net is showing error, you can check in the original application 2nd table from top

Aplication is displaying worng values

Thu, 15 Mar 2012 10:42:17 GMT

any help any one

Re: Aplication is displaying worng values

Thu, 15 Mar 2012 10:54:13 GMT

You need to start verifying from the details first, not the sums. Start by finding one data row in your excel-sheet and match the exact row in QlikView. Are you sure you are reading the correct version of the excelfile? Also try first to read it without crosstable just for verification, then add crosstable and verify. This way you will find which step fails.

If all details are correct, but the sums fail then start looking for duplicates or missing rows. Your sample script and application is too complex to debug with having access to the full data.

Olof Laurin, Senior Consultant at Tacticus AB, http://www.tacticus.se

Aplication is displaying worng values

Thu, 15 Mar 2012 11:24:44 GMT

Hi Laurin,

Yes i am using the correct version of excelfile, i have crossed check the values both in excel and application there the application is taking some extra values, and when i readit without crosstable the values came correct but i have to use cross table i am not able to create chart with individual values, can u suggest any idea

Aplication is displaying worng values

Thu, 15 Mar 2012 11:58:30 GMT

When you do your crosstable read, the first 17 columns in your read are duplicated in your final table. The number of duplicates depends on the number of cross-months that you have, in your case 13 I think.

To show the correct value you need to select only one "Months", for example Dec-10.

But I don't think you want to duplicate the LMAT-values at all so you need to split this into two tables, one containg non-duplicated LMAT and one containg the LEUData. To make this work you need to make a key between the tables which might be a bit difficult.

Another option is to use Set Analysis on the sum( LMAT'11)/1000, like

sum({$<Months={'Dec-10'}>}LMAT'11)/1000

Olof Laurin, Senior Consultant at Tacticus AB, http://www.tacticus.se

Aplication is displaying worng values

Thu, 15 Mar 2012 12:29:02 GMT

Hi Laurin,

i have used the expression wch you have give, the total came correct but the individual values are wrong in the table, as for the other method i am trying to break the table in parts, hope its works