topic Re: Expression to show measures in % in QlikView

Expression to show measures in %

Fri, 01 Aug 2014 05:42:55 GMT

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

Re: Expression to show measures in %

sujeetsingh — Fri, 01 Aug 2014 06:05:46 GMT

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

Re: Expression to show measures in %

Fri, 01 Aug 2014 06:17:21 GMT

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

Re: Expression to show measures in %

sujeetsingh — Fri, 01 Aug 2014 06:44:49 GMT

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.

Re: Expression to show measures in %

Fri, 01 Aug 2014 09:18:39 GMT

I will apply this logic and let you know.

Thanks Sujeet.!!