Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jrahul9797
Contributor

Can we change number format row-wise in Qlik sense?

I have created a table with a dimension having 3 values, average, high and low, for 5 variables (check the attached image for reference).

Please consider the last 3 variables. I want the values in the first 2 rows(High, Low) to be in percentage format and the 3rd row to remain in the same format.

Can you please guide me towards the solution? Thanks.

Best Regards

4 Replies
OmarBenSalem
Esteemed Contributor

Re: Can we change number format row-wise in Qlik sense?

alter ur expressions like this:

if(YourDim='High' or YourDim='Low', Num( sum(Measure) ,'# ##0,00%') , Num( sum(Measure) ,'# ##0,00') )

jrahul9797
Contributor

Re: Can we change number format row-wise in Qlik sense?

I was trying something like this but it's not working for me. Below is the expression that I had written:

avg(Aggr(If(Segments = 'High',

If(

Sum([Total Sales]) > AVG(TOTAL AGGR(Sum([Total Sales]),[Territory Name])),

num(AVG({$<[Territory Name]=>} AGGR(sum([Total Sales]),[Territory Name],Segments))/AVG({1} total AGGR(sum([Total Sales]),[Territory Name],Segments))-1,'##.00%')),

If(Segments = 'Low', 

If(

Sum([Total Sales]) < AVG(TOTAL AGGR(Sum([Total Sales]),[Territory Name])),

num(AVG({$<[Territory Name]=>} AGGR(sum([Total Sales]),[Territory Name],Segments))/AVG({1} total AGGR(sum([Total Sales]),[Territory Name],Segments))-1,'##.00%')),

num(AVG({1} AGGR(sum([Total Sales]),[Territory Name],Segments)),'##,###.00')

)), [Territory Name], [Segments]))

Please let me know where am I going wrong? Thanks.

Re: Can we change number format row-wise in Qlik sense?

Would you be able to share a sample to look at this?

jrahul9797
Contributor

Re: Can we change number format row-wise in Qlik sense?

I have created an inline table for segments with values high low and nation. PFA sample data

Community Browser