topic Re: Line chart Date Formatting in QlikView

Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 15:31:55 GMT

Hi,

In my line chart's expresion I am calculating trend using set analysis and limiting it to current date to 30 day's back (One month trend)

Current date selection is being made by a calendar object.

If user selects 5/24 line chart should populate 4/24-5/24.

I have all this working but my line chart is showing all the dates 4/24, 4/25 4/26 ............................ 5/24.

Requirment Questions:

1) just show 4/24 nothing in between and 5/24 at the end as in image below

2) Currently I have date in MM/DD/YYYY format (4/24/2012) how can I change it to just MM/DD format in the chart

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 16:37:21 GMT

Hi,

1. can you post the expression you're using in the chart?

2. Do you have a Calendar table with all the possible date dimensions? If not, I'd recommend you to do it. In the Calendar table, you would create another field in this table using the date() function date(YourDateField, 'MM/DD'). Another option is to use a calculated dimension (using the same date() function), which is not really recommended because calculated dimensions may slow down the app performance.

Hope this helps you

regards,

Fernando

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 17:49:01 GMT

Here's the expression i'm using:

=Money(sum({< Date = {'>=$(=Date(vPriorMonthDate))<=$(=Date(VarCurrentDay))'} >} Balances_Daily_Deposits_Actual),'$#,##0.00')/1000000000

And I have master calendar in my script for date.

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 17:52:33 GMT

Is it possible to show just 4/24 and 5/24 and no dates in between ?

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 18:00:25 GMT

The problem with your expression is that the set analysis is using a date range, and every data in that range will appear in the chart.

Maybe if you change your expression to:

Money(sum({< Date = {'$(=Date(vPriorMonthDate)), '$(=Date(VarCurrentDay))'} >} Balances_Daily_Deposits_Actual), '$#,##0.00') / 1000000000

The idea is that in the set analysis you'll use only the two dates, not the date range. Maybe you'll have to adjust the date format so that it works ok.

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 18:17:36 GMT

With your expression it says no data to display

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 19:09:31 GMT

Try this:

Money(sum({< Date = {'$(=Date(vPriorMonthDate))', '$(=Date(VarCurrentDay))'} >} Balances_Daily_Deposits_Actual), '$#,##0.00') / 1000000000

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 19:19:38 GMT

Fernando,

I think you got my question wrong.

Idea is to have all the dates calculating in line chart but just display start and end date of the calculation

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 19:57:34 GMT

Oh, now I understood. Sorry.

I think that you try doing this: Chart Properties>Axes>Dimension Axis>check the Continuous option.

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 20:04:12 GMT

with continuos option checked I have only one date displayed with amount of space I'm showing the line chart

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 20:07:59 GMT

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 20:20:38 GMT

A "workaround" would be to force the date to be displayed as text in Chart Properties>Presentation>Text in chart

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 20:32:20 GMT

Fernando,
How I can have dimension axis and not show date on it.?

Re: Line chart Date Formatting

fosuzuki — Wed, 27 Jun 2012 20:46:22 GMT

Chart Properties>Dimensions>Settings for selected dimension>uncheck "Show legend".

Re: Line chart Date Formatting

onetwothree123 — Wed, 27 Jun 2012 20:57:33 GMT

If I do that its not showing the Dimension Axis at all