topic Re: Number format within a Chart in App Development

Number format within a Chart

crowegreg — Tue, 18 Jul 2017 20:56:20 GMT

Shown is my set expression within a measure on a chart:

if(vMeasurement = 'Count',

Count({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'}>}[Incident Number]),

Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'}>}[Duration])

)

By the if statement, I will either be displaying a number or a duration. How do I change the formatting of the number within the chart? I've tried using custom, and adding 'Interval' to the part of the expression with the sum of the duration, but I can't get it to work.

Re: Number format within a Chart

mjtaft2017 — Tue, 18 Jul 2017 22:09:57 GMT

Can you give a little more information? What is your dimension? What does your data look like? What does your chart look like?

Re: Number format within a Chart

crowegreg — Tue, 18 Jul 2017 22:32:03 GMT

Sample Data:

Incident #, Month, Duration, Priority

INC001, Jan, 05:25,High

INC002, Jan, 00:45,Critical

INC003, Jan, 02:30,High

INC004, Feb, 01:15,High

INC005, Feb, 02:33,High

INC006, Feb, 00:45,High

INC007, Feb, 03:10,High

The dimension for my chart is Month.

If I have a bar chart, based on count of Incident #, chart will show for Jan -3, Feb -4. The format of the measure will be number.

If I have a bar chart, based on sum of Duration, chart will show for Jan - 08:40, Feb -07:43. The format of the measure will be duration.

What I'd like to do is combine these 2 bar charts into 1 chart, using a variable to select either count or duration. But I can't figure out how to change the format of the measure between number and duration. I believe I can use custom, and then properly format the set statement, but I can't get it to work.

Re: Number format within a Chart

antoniotiman — Wed, 19 Jul 2017 15:44:17 GMT

Hi Greg,

see Attachment.

Regards,

Antonio

Re: Number format within a Chart

crowegreg — Wed, 19 Jul 2017 15:58:45 GMT

Hi Antonio,

How do I properly view what you have sent me? I only see the load statement. I already have the data loaded.

Thanks,

Greg

Re: Number format within a Chart

antoniotiman — Wed, 19 Jul 2017 16:13:01 GMT

You don't see this

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 16:22:10 GMT

Antonio - he is using Qlik Sense. Your app is in Qlik View

Re: Number format within a Chart

antoniotiman — Wed, 19 Jul 2017 16:24:04 GMT

My apologies, I'm sorry.

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 16:25:09 GMT

I am trying this but so far not able to get both axis to display -- I put the values on the bars but that isnt what you want.

Maybe try adding as an alternate measure? I am going to try that

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 16:35:06 GMT

I tried adding as alternate measure then the user can display either way

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 16:37:24 GMT

Actually --- this is what it looks like for the user. They can choose from the Measures they want to view on the Y axis.

Re: Number format within a Chart

crowegreg — Wed, 19 Jul 2017 16:46:12 GMT

Thank you for all the suggestions.

I thought within a chart, within a measure, when you select the "Number formatting" you can select custom, and then format the result accordingly. As an example:

If I'm counting the number of records, I want the display to be a number. ex: 7

If I'm summing the duration, I want the display to be a duration. ex: 05:25

What is being displayed within the chart will be controlled by a button which the user selects, either "Count" or "Duration." Please note, I do not want two charts. I'd like one chart, that toggles between "Count" and "Duration".

Both views are displayed below.

Hope this helps. In summary, if the user clicks on "Count", the first chart should be displayed. If the user clicks on "Duration", the second chart should be displayed.

Thanks for all your assistance!!

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 16:52:17 GMT

Ok - I get it. Did you look at the last image I sent? The user can essentially toggle on the measures by selecting that little carrot that shows on the Y axis. Then there is no need for 2 buttons 🙂

Re: Number format within a Chart

crowegreg — Wed, 19 Jul 2017 16:56:08 GMT

I'll try that, but I'd like to stay within my original thought.

Throughout my app, I make use of the buttons. I'm gaining new user acceptance by using those buttons, and I like the way they work.

I had read somewhere you can control what is being displayed within a chart by properly formatting the set expression. That's what I originally tried.

Re: Number format within a Chart

mjtaft2017 — Wed, 19 Jul 2017 17:17:38 GMT

I will give that a try and post it - I haven't used that so it will be a good exercise for me

Re: Number format within a Chart

crowegreg — Wed, 19 Jul 2017 19:15:42 GMT

I've been doing some additional testing.

If I have the measure formatted as 'Auto', and have this set expression,

Interval(Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Duration]),'h:mm')

the display is correctly formatted as 'hh:mm'

But, once I put that statement within an IF statement,

if(vMeasurement = 'Count',

Count({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Incident Number]),

Interval(Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Duration]),'h:mm')

)

it is incorrectly formatted as 'hh.#####'

Re: Number format within a Chart

mjtaft2017 — Thu, 20 Jul 2017 19:40:26 GMT

Greg -

I think you need another right paren at the end of yours ---

Try this:

If(vMeasurement = 'Count',

Count({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Incident Number]),

If vMeasurement = 'Duration', Interval(Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Duration]),'h:mm')))

If you don't want to do that format --- then you at least need an additional parenthesis on yours.

if(vMeasurement = 'Count',

Count({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Incident Number]),

Interval(Sum({$<MI_Priority = {'Critical','High'},FY_Year = {'$(vFYYear)'},$(vDivision) = {'Yes'}>}[Duration]),'h:mm')

))

Re: Number format within a Chart

crowegreg — Thu, 20 Jul 2017 19:58:21 GMT

Thanks, but no doesn't work. You 1 to many ')'.

I've read a lot of posts regarding the formatting of data that is within an 'IF' statement. But nothing to do with a duration.

Re: Number format within a Chart

mjtaft2017 — Thu, 20 Jul 2017 21:13:43 GMT

Since I'm new too - I was wondering how you were creating your buttons in QS. Did you use the extension qsVariable?

If you haven't checked this -- check it out.

Cycle dimensions using a variable button or dropdown

https://community.qlik.com/docs/DOC-17359

Re: Number format within a Chart

crowegreg — Thu, 20 Jul 2017 22:00:38 GMT

The buttons I've displayed up above were created using and extension named 'Sheet Navigation & Actions.' I believe my co-worker located it. It provides great flexibility in design and usability. When we created this an app for an iPad, to worked out well.