Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

duplicates

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.

3 Replies
swuehl
MVP
MVP

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

raadwiptec
Creator II
Creator II
Author

Hi swehi

actual data from source - below intial date is blank.

      

CountryPrinterCodeStatusDestinationPiecesIntial DateLast DateUpdate Date
UKDell- IM03DEM03SoldSweden1 09/09/201501/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.

      

UKDell- IM03DEM03SoldSweden1 09/09/201501/02/2016
UKDell- IM04DEM04SoldSweden101/02/201609/09/201501/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..

ciaran_mcgowan
Partner - Creator III
Partner - Creator III

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)