Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Could you post a small sample QVW that demonstrates the issue?
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..
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)