Expression to show measures in %

[#1]

Hi,

I have to create an expression to show 2 measures in % using Bar chart(stacked) and having the below fields.    

I have some 7 Sol_App as Dimension and Solution ID, Sol_flag= Created(New), Sol_flag= Reused.

@

Expression 1: % of New solution by Application.

Expression 2: % of Reused solution by Application.

Could someone pls help me on logic how to create the expression for this? I'm new to QlikView.

Regards

Velan

[sujeetsingh]

At number option in properties there is option of show in percentage you can check it.

Please explain in more words.

If possible post a sample please

[#3]

Hi Sujeet,

Thanks for your comments. In Number tab we have that option and I have used it before.

if(GetFieldSelections(Sol_Application)='LG',

count({<Sol_flag={'Created'},Sol_Application={'*LG*'}-{'Asia Commodity Template'}>}count(DISTINCT SOLUTION_ID)). This is just a base. We need to create from this expression.

Likewise I need to create to show the 2 measures, New Solution & Reused solution in %.

Regards

Velan

[sujeetsingh]

Use num() fumction to do this

You can use as

if(GetFieldSelections(Sol_Application)='LG',

num(count({<Sol_flag={'Created'},Sol_Application={'*LG*'}-{'Asia Commodity Template'}>}count(DISTINCT SOLUTION_ID) ,'#,##0.00%')

Hope it helps.

[#5]

I will apply this logic and let you know.

Thanks Sujeet.!!