Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
I want the 9th row(Table is transposed) of my table to display
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.
Go to Solution.
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'))
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.
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.
Thanks Mr Whiteline