Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can we override the specified number format in tables...

Hi all,

I have a doubt wether we can override the specified number format in table for a particular row.

My question will be more clear to you after looking at the file I attached.

My requirement:

I want the 9th row(Table is transposed) of my table to display

-40%

-.26%

-.10%

-31.51%

and i can't keep the number format as expression default.

Please let me know if anyone knows the solution. I am strugling with it from past few days and have tried my best.

Regards

Sagar Gupta

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

Just set expression default format for all expressions.

Then correct your expressions this way:

=if(RowNo()='9', num($(vExpenditure), '#0.00%') , num(sum(Expenditure), '$#,##0'))

View solution in original post

4 Replies
whiteline
Master II
Master II

Hi.

You can set number format  as expression default and then manually decide witch format to use for each expression.

Function num() can get you what you want.

You can even create more complex text representation than just changing a number format with dual() function.

If by 'row' you mean a particular dimension value, use if() statement to assign different number format depending on  the dimension values.

Not applicable
Author

Hi Whiteline,

Thanks a lot for reply, but I already tried all these options and none is working for me.

It would be much better if you can make a sample file and send it to me.

Regards

Sagar Gupta

whiteline
Master II
Master II

Hi.

Just set expression default format for all expressions.

Then correct your expressions this way:

=if(RowNo()='9', num($(vExpenditure), '#0.00%') , num(sum(Expenditure), '$#,##0'))

Not applicable
Author

Thanks Mr Whiteline

Regards

Sagar Gupta