topic Re: How to get chart to display correct label, not the expression itself? in QlikView

How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 16:26:11 GMT

I need the x-axis to display the hours, not the expression itself.

For instance if vTimeZone= EST I want the x-axis to look like this:

How can I make this change?

Update:

Under dimensions tab, I selected table then added the expression:

=ConvertToLocalTime(Hour,
if(vTimeZone= 'IST','GMT+09:30',
if(vTimeZone= 'EST','GMT',
if(vTimeZone='GMT','GMT+05:00'))))

Now the chart displays

How can I just get it to display the time and not the date? Can I also have it labeled EST?

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 16:29:38 GMT

Try an expression like this for Label on the dimension tab

='Hour (' & vTimeZone & ')'

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 16:34:44 GMT

That works! but is there a way to get it only to display only the time and not the date?

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 16:40:21 GMT

May be like this

=Time(ConvertToLocalTime(Hour,
if(vTimeZone= 'IST','GMT+09:30',
if(vTimeZone= 'EST','GMT',
if(vTimeZone='GMT','GMT+05:00')))), 'hh:mm')

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 16:49:55 GMT

That displays the same results with the date and time

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 16:52:38 GMT

Can you share a sample to look at?

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 17:10:12 GMT

This is all I can provide:

Which is data for the hour field (listed in EST)

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 17:17:28 GMT

As an image? can you provide this in an Excel file?

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 17:29:36 GMT

Yes, here you go- thanks!

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 17:37:11 GMT

Seems to work for me

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 18:07:58 GMT

When I used that expression, it changed the output of my graph

from

Re: How to get chart to display correct label, not the expression itself?

sunny_talwar — Tue, 12 Sep 2017 18:10:09 GMT

Did you fix your hour field in the script?

Table:

LOAD Time(If(IsNum(Hour), Hour, Time#(Hour, 'hh:mm')), 'hh:mm') as Hour

FROM

[..\..\Downloads\Hour data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: How to get chart to display correct label, not the expression itself?

Anonymous — Tue, 12 Sep 2017 18:24:04 GMT

I made the fix and it works, thank you for your help!!!