topic Re: flags in script with external notepad or excel? in QlikView

flags in script with external notepad or excel?

fkeuroglian — Wed, 09 Apr 2014 02:35:00 GMT

Hi Experts

there is a way to create flag in the script but do them external to qlivkiew? using a notepad? or excel?

i want to create a normal flag in the script like

"if (lenguague = 1,'ESPAÑOL','ENGLISH') as Lenguague; but not do this in the load script, do it in a txt external or excel? and then include?

i try to do something like

Lenguague:

LOAD

CodLenguague,

Type,

$(Include=C:\Users\Desktop\NEWVER\FLAG.txt) // THIS IS THE NOTEPAD WITH THE FLAGS

FROM

EXAMPLE.QVD(QVD)

what would suggest or recommend? thank you a lot

i want to mantein and manage all the flags external qlikview

Fernando

Re: flags in script with external notepad or excel?

SergeyMak — Wed, 09 Apr 2014 04:21:21 GMT

It really depends on who will manage it?

1. You:

If there are not a lot of matches and have only one field for replacing you can leave it in qvs and use ApplyMap and Mapping load. Otherwise you can have separate xls file and join these data later.

2. Your users:

I think it would be better to have everything in xls, and use joins or ApplyMap

In your example you can use Mapping Load and ApplyMap. Mapping load you can move to the external qvs file.

Re: flags in script with external notepad or excel?

tresB — Wed, 09 Apr 2014 04:52:50 GMT

You can do that. I am not sure if you are asking for suggestion or how-to-do. If it is how-to-do, then let me tell you that you are almost there. Only thing may be you are doing wrong is a comma or semi-colon. If it is your last statement in the load then you don't need a comma either in the external file or in the load statement itself. And no semi-colon for eithe of the cases.

Re: flags in script with external notepad or excel?

fkeuroglian — Wed, 09 Apr 2014 12:52:45 GMT

Thank you both of you!

two different solution works fine!

I put an example , thank you again

Fernando

---------------------------------------------------------------------------------------------------------------------

EJECUTIVOS:

LOAD

CodEmp,

NombreEmpl,

Rubro,

$(Include=C:\Users\fkeuroglian\Desktop\NEWVER\Banderas.txt)

FROM

PruebaBanderas.qvd

(qvd);

---------------------------------------------------------------------------------------------------------------------