Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am beginner to Qlikview.
Suggest me on this,
1. I have loaded the data from DB, store into QVD.
And now every time I will load QVD, that mean I will not have recent data loaded?Right?
I will have only that data which is in QVD only? Right ?
2. I want to put the condition of not null of field in expression that ,
eg. Count(if( I need here (not null values of 'field' )only)
Hot to write this?
Hi,
1. On the first point you need delta load or Incremental load of the new data on your QVD or else need to refresh the new data if there is few rows on the table. Also for this view some of the Incremental load treads on the community.
2. On this you have to filter the null values you can filter them two ways first from the load script second on the front end with the help of the set analysis.
Regards
Anand
2. Drop all clauses that check for NULL values. Count() will ignore NULLs by default.
If you want to count the number of NULL vlaues in a field, use the NullCount() function.