Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

Creator
Creator

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

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