topic ReLoading The Data Based On Condition in QlikView

ReLoading The Data Based On Condition

Fri, 03 Jun 2011 10:38:28 GMT

Hi ,

I am facing the problem to retrieve the Data based on the condition on a field in editscript.

I have loaded one XL file into Qlikview (I have also attaching the Xl file With this post)

Test:

Here I need Like this,

NoRead=NoReads

!NoRead=GoodReads

NullValues=MissingReads

For This I write the query like this

In the DataBase:

select CASE A WHEN 'NoRead' THEN 'NOReads' ELSE CASE WHEN A<>'NoRead' Then 'GoodReads' Else 'MissingReads' End END AS ReadType from Test

And This is working well.

In The QlikView EditScript:

if(A='NoRead','NoReads',if(A<>'No Read','GoodReads','MissingReads'))as ReadType But This Is not showing the result exactly what i want.

Can you Reply me With the solution for this Problem.

Thanks....

Miguel_Angel_Baeyens — Fri, 03 Jun 2011 10:44:00 GMT

Hello,

First of all, I'll check for null/missing/empty values:

If(Len(Trim(A)) = 0, 'MissingReads', If(A = 'NoRead', 'NoReads', 'GoodReads')) AS ReadType

Hope that helps.

BI Consultant

Fri, 03 Jun 2011 17:47:41 GMT

Hi Miguel,

Thanks for your Reply

Yes Its really helps me.

Thanks