Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

parks399
New Contributor II

Help with adding formatting to a measure

I am trying to add formatting to a measure.  The formula says it is ok, but the data is missing when you close out of the function writer.  Can you tell me what I may be doing wrong with this set analysis statement with the added formatting???

=num((sum ({$<Scenario={'$(vCurFcst)'},MthNameLong={'$(vCurMth)'}>} Revenue)/1000000));$#,##0.#M;($#,##0.#)M

Tags (1)
11 Replies
ahaahaaha
Honored Contributor

Re: Help with adding formatting to a measure

Hi Peggy,

Can you provide a fragment of the original data and the result that you want to get after formatting?

Regards,

Andrey

anushree1
Contributor II

Re: Help with adding formatting to a measure

Hi,

Please try this:

=num((sum ({$<Scenario={'$(vCurFcst)'},MthNameLong={'$(vCurMth)'}>} Revenue)/1000000),'$#,##0.#M;($#,##0.#)M')

parks399
New Contributor II

Re: Help with adding formatting to a measure

Thanks for the recommendation.  I see you added a closed parenthesis at the end.  Should I add the open parenthesis after the equal sign at the start of the equation?  I will try this whe I get in the office!  Again, thanks for the reply!

Highlighted
parks399
New Contributor II

Re: Help with adding formatting to a measure

I would love to.  Let me figure out how.  I'll do that when I get in the office.  Thanks for the reply.

parks399
New Contributor II

Re: Help with adding formatting to a measure

Hi!  How do i attach the app so you can see my issue? 

parks399
New Contributor II

Re: Help with adding formatting to a measure

It didn't work, but I'm still at it.

anushree1
Contributor II

Re: Help with adding formatting to a measure

HI Peggy,

You could post the app by clicking on use advanced editor option that appears on the right hand corner after reply option is clicked

parks399
New Contributor II

Re: Help with adding formatting to a measure

You are being very helpful, but I don't have that option in my view. Am I missing something??WhatISee.JPG

anushree1
Contributor II

Re: Help with adding formatting to a measure

I think you are directly getting  onto the inbox and replying on the latest thread instead i suggest double click on the thread to open the complete conversation and then hit reply and then you should be able to choose the advanced editor option