Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Partner
Partner

flags in script with external notepad or excel?

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: flags in script with external notepad or excel?

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);

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

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: flags in script with external notepad or excel?

Hi

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.

Regards,
Sergey
Highlighted
MVP
MVP

Re: flags in script with external notepad or excel?

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.

Highlighted
Partner
Partner

Re: flags in script with external notepad or excel?

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);

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

View solution in original post