Forum Discussion

qmartiny's avatar
qmartiny
Helper III
4 years ago
Solved

COMBINEVALUES ignore blank

Hello,   (I have the following COMBINEVALUES that concatenates multiple flags into one field to get all the flags in one place. I added a UNICHAR for line break and it works fine, however still sho...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    How about:

    qcheck total flag text = 
VAR dealsize = 1
VAR dealscore = BLANK ()
VAR R4Q = 3
VAR owner = 4

VAR FlagList = 
    FILTER (
        {
            dealsize,
            dealscore,
            R4Q,
            owner
        },
        NOT ISBLANK([Value])
    )

VAR Result =
    CONCATENATEX (
        flaglist,
        [Value],
        "|"
    )

RETURN
    Result
bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

How about:

qcheck total flag text = 
VAR dealsize = 1
VAR dealscore = BLANK ()
VAR R4Q = 3
VAR owner = 4

VAR FlagList = 
    FILTER (
        {
            dealsize,
            dealscore,
            R4Q,
            owner
        },
        NOT ISBLANK([Value])
    )

VAR Result =
    CONCATENATEX (
        flaglist,
        [Value],
        "|"
    )

RETURN
    Result
qmartiny's avatar
qmartiny
Helper III
4 years ago

Legend.


Thank you so much for your help! It's humbling to see how good people are at this.


Have a great evening

 

Quentin