Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If Match Statement

Questions:

1 - Can I write an If(Match) statement as a Maser Item?

2. If yes - then what am I doing wrong with expression -

  - if(match({<transcript_status_code={"A","X"}, category ={'Skill Area 01/08 }>}), employee_first_name&' '&employee_last_name)

3. If no - what are my other options? Just writing it in the script?

1 Solution

Accepted Solutions
sunny_talwar

May be a final resident load after all the joins to create the if statement

Temp:

LOAD *

FROM ...;

Inner Join (Temp)

LOAD *

FROM ....

....

FinalTable:

LOAD *,

           If Statement here.....

Resident Temp;

DROP Table Temp;

View solution in original post

7 Replies
sunny_talwar

I guess you are combining If and set analysis... try like this

If(Match(transcript_status_code, 'A', 'X') and category = 'Skill Area 01/08', employee_first_name&' '&employee_last_name)

Not applicable
Author

I'm trying to make a Maser Item (Dimension) that will be a drilldown.

One Field I have (Work_Name)

The Second will be only the name of the Employee whom has the A or X Transcript Status for the Category.

But this doesn't work.

It's giving me the count but not the detail. Below is what I am applying to the drill - down in the chart.

Not applicable
Author

So I have come to find out that the If Match statement I am trying to write within the Dashboard won't work. I believe I need to write it in the script. Here's my problem -

I have 5 SQL statements. I save them all to a QVD file and then I "drop" the table.

Then at the end I do an Inner Join on all 5 tables.

I want to create IF Match statements somewhere in there... I just don't know where or how I would do it. The Statements I need to create have fields from multiple SQL within the app.

See example.

The 5 Circled are my SQL Statements -

At the bottom of each is where I store the SQL to a QVD. See below.

Then I have my Inner Joins for the QVD files.

I want to create another SECTION to where I can write Conditions (IF Match) statements that could potentially have fields from multiple sections in one IF Match.

Any and all help on how to do this would be great.

sunny_talwar

May be a final resident load after all the joins to create the if statement

Temp:

LOAD *

FROM ...;

Inner Join (Temp)

LOAD *

FROM ....

....

FinalTable:

LOAD *,

           If Statement here.....

Resident Temp;

DROP Table Temp;

Not applicable
Author

Like this?

sunny_talwar

I think so.... just make sure that you have used the name Temp for your inner join table

Capture.PNG

Apologize for the bad typing

Not applicable
Author

Ahh yes. I do have the Temp name in place. Okay - thanks! I shall try it!