topic Re: How to format the set analysis code? in QlikView

How to format the set analysis code?

Thu, 05 Dec 2013 13:59:42 GMT

How to format the set analysis code?

Re: How to format the set analysis code?

Anonymous — Thu, 05 Dec 2013 14:02:06 GMT

what kind of formatting are you talking about.

Could you provide some example as to what you are trying to achieve.

Re: How to format the set analysis code?

Anonymous — Thu, 05 Dec 2013 14:02:40 GMT

Hello,

What do you mean by "format the code"?

Regards

Vincent

Re: How to format the set analysis code?

Thu, 05 Dec 2013 14:12:48 GMT

As long as it gives you the correct results (interpenetrated correctly by QlikView) can you format the code in the way you find it easy to read and work with. I rarely write set analysis expressions that are of the length or complexity that it requires to split up into multiple rows to be easy to understand.

Re: How to format the set analysis code?

Thu, 05 Dec 2013 16:10:47 GMT

Some time set analysis code contains numerous conditions and calculation.

It is better to break and format the code with in editor for better readability

Re: How to format the set analysis code?

kouroshkarimi — Thu, 05 Dec 2013 16:17:04 GMT

Format the code in whatever way works for you.

Re: How to format the set analysis code?

jaimeaguilar — Thu, 05 Dec 2013 20:20:15 GMT

Hi,

If you're using an expression with set analysis inside a text object or any other object that doesn't have the number tab in properties, you can apply format with functions,

for example,

let's suppose you have this expression:

Sum({$<Country={'Mexico'}, Year={ $(=Max(Year) }>} Sales)

if you don't apply any format it will appear with default formatting,

then if you wanted to give some format to the number, you could do this:

num(Sum({$<Country={'Mexico'}, Year={ $(=Max(Year) }>} Sales), '$#,##0.##')

this way the result will be a number with $ symbol, a comma every threee number and two decimals for cents,

regards