ReLoading The Data Based On Condition

[#1]

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:

A	B
NoRead	1
High	2
High	3
Normal	4
NoRead	5
Normal	6
High	7
	8
High	9
	10

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 · Accepted solution]

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.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

Hi Miguel,

Thanks for your Reply

Yes Its really helps me.

Thanks