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: 
mwscott1
Creator
Creator

Conditional Show of Object

I am using a script to pull in the header information of an Outlook .MSG file. I am pulling back From:, To:, Date:, Subject. (See Script below). From this I am trying to make a Text Object conditionally show based on key words that might be present in the subject line. For example, if subject = "Good Morning" the text box will show.

// The first statement should create a table with three fields named @1, @2 and @3

_tmp:

LOAD *

From (txt, codepage is 1252, no labels, delimiter is '\t', msq, no eof);

// Here we filter out fields that are unrelated to those we want to keep

_tmp2:

LOAD Subfield(@1, ': ', 1) as Header, Subfield(@1, ': ', 2) as Info

Resident _tmp

Where WildMatch(@1, 'From: *', 'To: *', 'Date: *', 'Subject: *', 'Message Body: *');

DROP Table _tmp;

5 Replies
Not applicable

Hi,

If you could post the MSG file I will do some testing for you right away!

mwscott1
Creator
Creator
Author

Thank you for your help, the .msg file attached.

Not applicable

Thank you for the file. Is the qvw attached any good?

I couldn't find data in your file so appended some imaginary data for testing.

Scenario A - text object shows up when key word "Good Morning" is entered

Capture.GIF

Scenario B - text object hides when key word entered is not available in the Subject line

Capture1.GIF

Warm regards,

Nish

beck_bakytbek
Master
Master

Hi Melvin,

look at this: https://www.youtube.com/watch?v=7mrZQvbN0_U

i hope that helps to resolve your issue

Beck

Not applicable

Hi there!

Have you had a chance to look at my reply yet?

Warm regards,

Nish