Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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?

1 Solution

Accepted Solutions
Highlighted

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

Seems to work for me

Capture.PNG

View solution in original post

12 Replies
Highlighted

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

Try an expression like this for Label on the dimension tab

='Hour (' & vTimeZone & ')'


Capture.PNG

Highlighted
Contributor III
Contributor III

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

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?

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')

Highlighted
Contributor III
Contributor III

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

That displays the same results with the date and time

Highlighted

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

Can you share a sample to look at?

Highlighted
Contributor III
Contributor III

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

This is all I can provide:

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

Highlighted

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

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

Highlighted
Contributor III
Contributor III

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

Yes, here you go- thanks!

Highlighted

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

Seems to work for me

Capture.PNG

View solution in original post