topic Re: Field with hyphens in QlikView

Field with hyphens

evansabres — Thu, 13 Aug 2015 14:55:59 GMT

Hello -

I have a field that appears in this manner, name of the field is [Campaign Name] : (The field is an xlsx file)

NAME - 07032015 - TITLE

I also have an inline table:

tbl_CAMPAIGNS:
LOAD * INLINE
[ cmpNID, cmpCAT
1, BRAVES
2, KNIGHTS
3, JACKETS
4, HHH
5, CLUB
6, COM
7, SURVEY
8, HC ];

In my script, I am using:

UPPER(TRIM(SubField([Campaign Name], '-', 1))) AS cmpCAT,

Also:

UPPER(TRIM(SubField([Campaign Name], '-', 2))) AS cmpNME,

This allows me to link the two tables so that I can have a list box from which to select the cmpCAT (Campaign Category)

The script runs with no issue and produces the list box in the manner I desire. However, when I click on a cmpCAT from the list box, my app does not produce any results.

Does my issue live in my scripting or is this a result of using an xlsx file?

Thank you.

Re: Field with hyphens

maximiliano_vel — Thu, 13 Aug 2015 14:59:13 GMT

Could you post some sample of the xlsx and expected results?

Re: Field with hyphens

awhitfield — Thu, 13 Aug 2015 14:59:51 GMT

Hi Evan,

can you upload your qvw and excel sheet?

Andy

Re: Field with hyphens

evansabres — Thu, 13 Aug 2015 15:31:31 GMT

Thank you for your time in replying. I made a silly mistake in my data, my scripting was spot-on for what I was trying to do.

Re: Field with hyphens

evansabres — Thu, 13 Aug 2015 15:31:36 GMT

Thank you for your time in replying. I made a silly mistake in my data, my scripting was spot-on for what I was trying to do.