topic If condition is not working problem in edit script? in QlikView

If condition is not working problem in edit script?

Thu, 10 Nov 2011 13:09:29 GMT

I've xlx data like below format.

CTCateg

No Read

ExLow

OS Low

High

No Read

Ex Low

OS Low

- I've one varaible which consist data like NoReads,GoodReads,MissingReads

- while loading itself the data should check based on the varaible for dat i written below code..

Table1:

LOAD CTCateg

FROM

[..\2_QVDGenerator\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where if(SubStringCount('$(vCtCateg)','NoReads')>0, CTCateg ='No Read',if(SubStringCount('$(vCtCateg)','GoodReads')>0, CTCateg>0,CTCateg<=0))

;

- Here the condition is if varaible is equal to NoReads it should display only No Read data or if varaible is equal GoodReads it should display other than NoRead and null values or if variable is equal to MissingReads it should display only null values.

But i'm not getting exact data..Can anybody help on this..

For ur reference i'm attaching my xls and qvw file also.

Re: If condition is not working problem in edit script?

Thu, 10 Nov 2011 14:04:49 GMT

Hi jacq,

as far as I understood you,my exam app should point into right direction

Note:

For testing purposes I used an inline-table as source.

I do not need a variable.

HtH

Roland

Re: If condition is not working problem in edit script?

john_duffy — Thu, 10 Nov 2011 14:13:02 GMT

Hello.

I have attached an example if which I create a resident table from the spreadsheet to determine Read Type. Using this field and the variable, I use the mixmatch command to determine which records to process.

Let me know if this helps.

John.

If condition is not working problem in edit script?

Thu, 10 Nov 2011 14:56:10 GMT

Roland,

I want to load the application based on variable. It is mandataory for my application.

John

Your example is fine. But i'don't want to load table data two times(i.e with help of resident load) in my application b'coz i have to load more than 100 fields based on this condition and other conditions for other fields also.

Thanks a lot for sharing your idea.. At lost i got solution for my task myself.

Code is:

Table1:
LOAD CTCateg
FROM
[..\2_QVDGenerator\Book1.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where
(if(SubStringCount('$(vCtCateg)','NoReads')>0, CTCateg ='No Read')
or if(SubStringCount('$(vCtCateg)','GoodReads')>0, CTCateg>0 and CTCateg <> 'No Read')
or if(SubStringCount('$(vCtCateg)','MissingReads')>0, CTCateg<=0))
;

Re: If condition is not working problem in edit script?

llauses243 — Fri, 11 Nov 2011 01:32:06 GMT

Hi,

This is my offer, with same result as Jhon Duff but with only a Load

Good luck, Luis

If condition is not working problem in edit script?

Fri, 11 Nov 2011 10:48:58 GMT

If the variable is empty i want to load all the values of CTCateg..

Can anyone help me according to above examples.