Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
siva_boggarapu
Contributor II

How to put the condition?

Hello There,

I have a filed called tax column. Here I need to put below three conditon into one condtion. How to make them into one condition in the designer part?

RT Fare Season 1: $550 (RT = roundtrip)

RT Fare Season 2: $700

RT Fare Season 3: $950

1 Reply
MVP
MVP

How to put the condition?

Hi Siva,

not sure if I understood completely:

You wanna set the field [tax column] depending on a value you retrieve from a different field (Season?)?

I think you could use a pick / match function combination in your script to achieve this:

LOAD

....

[SeasonField],

pick(match([SeasonField],'RT Fare Season 1', 'RT Fare Season 2','RT Fare Season 3'),'$550','$700','$950') as [tax column]

FROM ....;

There are also alternatives, like using a mapping table and applymap, if you got lot of seasons, this would probably better to maintain.

Hope this helps,

Stefan

Community Browser