topic Re: duplicates in QlikView

duplicates

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a scenario where there are columns called intial date , last date, and update date.. When the data is extracted from source many of the intial dates are blqnk or null. so in the front end expression i have provided an expression where it fills the intial data when blank taking data from the update date.

But the problem iam getting the values doubled now, in fact the lines are different

any solution here.

Re: duplicates

swuehl — Fri, 01 Jul 2016 08:58:54 GMT

Could you post a small sample QVW that demonstrates the issue?

Re: duplicates

raadwiptec — Fri, 01 Jul 2016 09:13:30 GMT

Hi swehi

actual data from source - below intial date is blank.

Country	Printer	Code	Status	Destination	Pieces	Intial Date	Last Date	Update Date
UK	Dell- IM03	DEM03	Sold	Sweden	1		09/09/2015	01/02/2016

In the front end I have added an expression stating if intial date is empty take last update date.. after which i get 2 lines as below.

UK	Dell- IM03	DEM03	Sold	Sweden	1		09/09/2015	01/02/2016
UK	Dell- IM04	DEM04	Sold	Sweden	1	01/02/2016	09/09/2015	01/02/2016

As i cannot supress the null values on intial dates because for certain update values are indeed blank..and i may need to keep it..

Re: duplicates

ciaran_mcgowan — Fri, 01 Jul 2016 09:43:15 GMT

You could use this in your charts?

if(Len(Initial)=0, NULL(), Initial)

Otherwise, you could create a flag in your script:

if(Len(Initial)>0, 1, 0) AS Flag.InitialDate

Then use set analysis in your charts

Only({<Flag.InitialDate={1}>} Initial)