Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mwscott1
Contributor

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

Re: Conditional Show of Object

Hi,

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

mwscott1
Contributor

Re: Conditional Show of Object

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

Not applicable

Re: Conditional Show of Object

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
Honored Contributor

Re: Conditional Show of Object

Hi Melvin,

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

i hope that helps to resolve your issue

Beck

Not applicable

Re: Conditional Show of Object

Hi there!

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

Warm regards,

Nish