topic Re: Duplicate Data in QlikView

Duplicate Data

NavinReddy — Thu, 29 May 2014 15:31:43 GMT

Dear All,

I have issue with Data

Actually i have 346 rows i have in Excel

But i created month field ,for that i loaded same data in 12 Times

Now i have 4152 rows i have

when i use count of rows 4152 its showing ,but actually 346 only

How can i Fix this issue please some one help me

I am attached QVW please find the QVW

Thanks In Advance

Niranjan

Re: Duplicate Data

Greg_Williams — Thu, 29 May 2014 15:32:54 GMT

Do you have a loop in your script?

Please share the script.

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 15:34:35 GMT

Hi,

open the Qvw you can find the Script

Regards,

Nianjan

Re: Duplicate Data

Gysbert_Wassenaar — Thu, 29 May 2014 15:37:32 GMT

Please explain what you want 'fixed'.

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 15:40:48 GMT

Hi Gysbert,

Actual data is 346,when i am using count its showing 4152

How can i fix this issue when i am using count it will show only 346

Best Regards,

Niranjan

Re: Duplicate Data

Thu, 29 May 2014 15:41:00 GMT

12*346 = 4152.

You are creating 346 records every time you concatenate

Re: Duplicate Data

Greg_Williams — Thu, 29 May 2014 15:43:25 GMT

Yes. So it appears the fields (e.g. 1 as Month, 'Jan' as MonthDesc, etc.) are causing the replication in content to grow the records to 4152.

Have you considered employing:

1 - Preceding Load

2 - Mapping load/apply map to refer to appropriate month

Have you removed the explicit concatenation to see if Qlik will do this implicitly? If so, this can give you insight into how QV is treating your forced concatenation.

Greg !

Re: Duplicate Data

Gysbert_Wassenaar — Thu, 29 May 2014 15:52:37 GMT

If you want a count of 342 then you need to load the data for only one month. You can't load 4152 records and get a record count of 342. Not in this universe at least. The math doesn't allow it.

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 15:52:40 GMT

Yes exactly ,

i didnt removed ,dont know how can i do this

e.g. 1 as Month, 'Jan' as MonthDesc,

how can i do it with out loding 12 times

Best Regards,

Niranjan

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 15:54:31 GMT

Yes , How can i break this

is there any way to with out using 12 times ,how can i create month field

Please guide me

Best Regards,

Niranjan

Re: Duplicate Data

Greg_Williams — Thu, 29 May 2014 16:03:19 GMT

When you load the data, the MonthDesc contains the months. When you select a month, it will show associated results. Are you attempting to duplicate the information? If not, then simply load the script once (no concatenation, use the original (top) load script once. It will contain 342 fields. Otherwise - you will have duplicated data that will exceed 342 as Jacob explains.

-Greg

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 16:07:41 GMT

when i use no concatinate i wont effect my data

can i use No cancatinate ,guide me i dont know exactly in this secnario

Best Regards,
Niranjan

Re: Duplicate Data

Greg_Williams — Thu, 29 May 2014 16:15:56 GMT

Can you share the data source with me?

Re: Duplicate Data

Greg_Williams — Thu, 29 May 2014 17:12:59 GMT

Are you able to insert a "date field" into the load script? If you can, this would greatly simplify your challenge. You could script month(<date field>) and you would be able to limit your data. Or perhaps, if you have xls files that have different months - these can be loaded and concatenated.

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 17:32:18 GMT

Hi Greg Williams,

Sorry for late response ,i attached Excel dump

please find the attachement

how can i insert date field i dont know this concept could you please guide me

how to do this

Best Regards,

Niranjan

Re: Duplicate Data

Anonymous — Thu, 29 May 2014 19:26:45 GMT

Hi, Niru Niru.

Here is a modification of your QVW that I think will show you how to solve your problem. I'm going to attach the same file to your other posts about this issue too.

Hope it helps.

Bruno.

Re: Duplicate Data

preminqlik — Thu, 29 May 2014 19:43:51 GMT

Load *,

month(date#(left(right(trim(filebasename()),6) ,3) ,'MMM')) as Month,

Year(date#(right(right(trim(filebasename()),6) ,2),'YY') ) as Year

from c:\book1.xls;

Re: Duplicate Data

NavinReddy — Thu, 29 May 2014 19:56:16 GMT

hi ,

in bar chart how can i show dollars comparison and SQF comparison

Regards,

Niranjan

Re: Duplicate Data

Anonymous — Thu, 29 May 2014 20:15:02 GMT

Hello, Niranjan.

Let's keep this discussion on this thread: Current Month

Cheers!