Forum Discussion

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper 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
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Quentin,

Are you just using it in a card visual? Could you send a screen shot of the output? I didn't get blank lines with my test measure. 

Will do some more testing my end as well.

qmartiny's avatar
qmartiny
Icon for Helper III rankHelper III
4 years ago

I am using it in a Matrix, as 'Values' example with | separator

 

With UNICHAR

 

 

 

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity 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
      Icon for Helper III rankHelper 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