topic Re: Formatting based on the dimension value. in QlikView

Formatting based on the dimension value.

Anonymous — Fri, 17 Feb 2017 08:59:44 GMT

Hi All,

I have a list of KPIs as a dimension. Which have various kinds of metrics like Totals, Costs, Percentages etc. I need to format the data based on the kind. For example, if KPI is related to cost, i need '$ #,###' as format and if Percentage '#.##%' ... using if else .. in the expression will do, but if I have many variations like above, it becomes complicated.

I have tried with keeping a column with the symbols to be added and appended it using (DataValue)&Wildcard. But this fails when the DataValue is null or empty.

Can we achieve this in QlikView? Or else is there any work around.

Thanks in advance.

Re: Formatting based on the dimension value.

vinieme12 — Fri, 17 Feb 2017 09:07:42 GMT

Hi Shiva,

please post a sample app or sample data, you can format expressions using NUM() function make sure you check expression default in Number tab

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm

Re: Formatting based on the dimension value.

sarvesh — Fri, 17 Feb 2017 09:09:39 GMT

Hi..Shiva,

You have to take measure of cost which is numeric value and then you can give the title "Cost" and you can set percentage of achieved from settings.

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

Regard's

Sarvesh Srivastava

Re: Formatting based on the dimension value.

Anonymous — Fri, 17 Feb 2017 09:27:16 GMT

Dear shiva
find the attach file

Re: Formatting based on the dimension value.

Anonymous — Fri, 17 Feb 2017 10:46:54 GMT

Please find the attachment explaining the requirement more clearly. Excuse me for not being clear in my requirement.

Re: Formatting based on the dimension value.

vinieme12 — Fri, 17 Feb 2017 10:52:24 GMT

Try

= NUM(if(wildmatch(KPI,'Percentage*'),Value/100,Value),Pick(WildMatch(KPI,'Percentage*','Ratio','Total*'),'#.0%','##.0','$##,###'))

Re: Formatting based on the dimension value.

Anonymous — Fri, 17 Feb 2017 11:03:23 GMT

Thanks Vineeth, But my expression is not as simple, am already using set analysis and if in future if variations increase like (now i have %,$, ratio and if they increase) Adding if else clause for everything makes it hard. Is there work around.

Re: Formatting based on the dimension value.

vinieme12 — Fri, 17 Feb 2017 11:04:50 GMT

Yes there is, wait a minute

Re: Formatting based on the dimension value.

vinieme12 — Fri, 17 Feb 2017 11:07:38 GMT

create one expression for each KPI and remove the KPI from dimension, you can then format from Number tab

Re: Formatting based on the dimension value.

Anonymous — Fri, 17 Feb 2017 11:20:33 GMT

That's a very cool idea Vineeth, but I have around 10 expressions already in my table. Your answer is perfect for a single column. But I think I can't use this approach in my case.

Re: Formatting based on the dimension value.

vinieme12 — Fri, 17 Feb 2017 11:22:17 GMT

Well; these two are the only possible ways afaik