topic Re: Reference line with Split Axis in QlikView

Reference line with Split Axis

josephinetedesc — Thu, 22 Dec 2016 02:06:46 GMT

Hi all not sure if I should have started a new discussion - but this follows on from thread 53449 (I could not search on it???)

anyway

I have this graph (I have taken away legends and window titles ...)

Note: I have formatted the date to display the dayname using www dd/MM/yyyy in the number tab

However, when I then drill down by sweeping with my mouse the dayname part disappears.

Why? (I notice it also happens with the Qlikview document from thread 53449.

Re: Reference line with Split Axis

vinieme12 — Thu, 22 Dec 2016 05:44:48 GMT

Strange , try

Ddd d/mm/yyyy

Re: Reference line with Split Axis

vinieme12 — Thu, 22 Dec 2016 05:46:17 GMT

Or another option would be to format the date field directly in your dimension

Date (field name, 'Ddd d/mm/yyyy')

Re: Reference line with Split Axis

josephinetedesc — Thu, 22 Dec 2016 06:05:02 GMT

Thanks vineeth

I tried that but did not work.

If you go to this site you will find the qvw document and it does the same thing - when you go to a smaller dimension the 'Mon" etc disappears.

Reference line with Split Axis | Qlik Community

Re: Reference line with Split Axis

avinashelite — Thu, 22 Dec 2016 06:27:14 GMT

I think we need to check the data association and how you have club the dimensions ....

Please share the app or the dimension expression and the expressions your using

Re: Reference line with Split Axis

josephinetedesc — Thu, 22 Dec 2016 12:46:41 GMT

Hi Vineeth

the thread below has a QlikView document called YearLabelsProblems - this shows the same problem.

Reference line with Split Axis | Qlik Community

https://community.qlikview.com/servlet/JiveServlet/download/220404-37690/YearLabelsProblems.qvw

Re: Reference line with Split Axis

avinashelite — Thu, 22 Dec 2016 13:19:52 GMT

try like this

Add a new date columns in script and use the same in the dashboard

Date(Date,'WWW DD/MM/YYYY') as New_Date

Please find the sample file attached

Re: Reference line with Split Axis

josephinetedesc — Thu, 22 Dec 2016 21:39:30 GMT

Hi Avinash

in the script I did the following:

TempCalendar:

LOAD

$(varMinDate) + Iterno()-1 As Num,

Date($(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

MasterCalendar1:

Load

TempDate AS DateFull,

Date(TempDate, 'WWW DD/MM/YYYY') as NewDate,

week(TempDate) As DateFullWeek,

WeekStart(TempDate) as DateFullWeekStart,

Year(TempDate) As DateFullYear,

Month(TempDate) As DateFullMonth,

Day(TempDate) As DateFullDay,

YeartoDate(TempDate)*-1 as CurYTDFlag,

YeartoDate(TempDate,-1)*-1 as LastYTDFlag,

inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,

date(monthstart(TempDate), 'MMM-YYYY') as DateFullMonthYear,

ApplyMap('QuartersMap', month(TempDate), Null()) as DateFullQuarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as DateFullWeekYear,

WeekDay(TempDate) as DateFullWeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

In the Properties - I changed the Expression default and then tried to change it to format WWW, DD/MM/YYYY:

Same Problem though.

Re: Reference line with Split Axis

avinashelite — Fri, 23 Dec 2016 05:28:46 GMT

You want this representation in the diemsion/column or you want to format the expression like this ??

if you set the format in the script for a column then it will work properly..if it the expression then I have not tried with that ...share the sample app let me check

Re: Reference line with Split Axis

josephinetedesc — Fri, 23 Dec 2016 05:54:38 GMT

Hi Avinash

I work in health - I am paranoid about privacy issues!

In any case It is nearly hometime and Christmas holidays

Thanks for your help

Re: Reference line with Split Axis

avinashelite — Fri, 23 Dec 2016 06:25:24 GMT

Aha enjoy friend ...merry Christmas

Re: Reference line with Split Axis

josephinetedesc — Fri, 30 Dec 2016 05:05:12 GMT

You know i wonder if the issue is the same as the one I am experiencing with my other discussion:

It looks like the continuous x axis (the date) is 355571.9 Maybe I need to do a floor date expression ...

Will check later