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

Hi bcdobbs 

 

Thank you so much for your reply!

It looked promising however maybe because I am using UNICHAR(10) as a line break still shows 'blank lines'

 

I tried with a separator instead and it works, however it keeps the separator in the string ex 

|||drivers||

Obivously expected would be to only keep the values non blank.. I tried to use FILTER/ISNONBLANK without luck,

 

Appreciate the help again!

 

Thank you


Quentin

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