topic Re: Conditional Show of Object in QlikView

Conditional Show of Object

mwscott1 — Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: Conditional Show of Object

Thu, 27 Apr 2017 18:10:58 GMT

Hi,

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

Re: Conditional Show of Object

mwscott1 — Thu, 27 Apr 2017 18:48:06 GMT

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

Re: Conditional Show of Object

Thu, 27 Apr 2017 22:18:38 GMT

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

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

Warm regards,

Nish

Re: Conditional Show of Object

beck_bakytbek — Fri, 28 Apr 2017 07:40:58 GMT

Hi Melvin,

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

i hope that helps to resolve your issue

Beck

Re: Conditional Show of Object

Fri, 28 Apr 2017 13:21:05 GMT

Hi there!

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

Warm regards,

Nish