Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor II

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

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'))

4 Replies
whiteline
Honored Contributor II

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

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

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

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
Honored Contributor II

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

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

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

Thanks Mr Whiteline

Regards

Sagar Gupta

Community Browser