Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

format issue

Hi all

I have a dimension like below

=aggr(if(Hour12<>'NA',Hour12),Hour12)   

here hour132 values having   01,02,03,04     like that

so my dimension values showing  01,02,03     but I want the result like

11:00 AM    12:00 PM    01:00 PM   like  that   how can I achieve this?

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: format issue

May be

Time(maketime(aggr(if(Hour12<>'NA',Hour12),Hour12) ),'hh:mm TT')

View solution in original post

10 Replies
Highlighted

Re: format issue

May be this

=Time(Aggr(If(Hour12<>'NA',Hour12),Hour12), 'hh:mm TT')

Highlighted
Specialist III
Specialist III

Re: format issue

it showing   all values like

12:00 AM   12:00 AM  only 

Highlighted
Master
Master

Re: format issue

Can you try this?

=pick(match(aggr(if(Hour12<>'NA',Hour12),Hour12),'01','02','03'),'11:00 AM','12:00 PM','01:00 PM')

Highlighted
Specialist III
Specialist III

Re: format issue

sunny its not working

Highlighted

Re: format issue

Can you share two images

1) =aggr(if(Hour12<>'NA',Hour12),Hour12)

2) =Time(Aggr(If(Hour12<>'NA',Hour12),Hour12), 'hh:mm TT')

Highlighted

Re: format issue

Hi,

is this what you are looking for?

QlikCommunity_Thread_303645_Pic1.JPG

regards

Marco

Highlighted
MVP & Luminary
MVP & Luminary

Re: format issue

I would suggest:

=aggr(if(Hour12<>'NA',MakeTime(Hour12)),Hour12)  

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Highlighted
Master III
Master III

Re: format issue

May be

Time(maketime(aggr(if(Hour12<>'NA',Hour12),Hour12) ),'hh:mm TT')

View solution in original post

Highlighted
Specialist III
Specialist III

Re: format issue

thanks rob

in your expression result am getting  full time format

like  12:00:00 PM     but I need  12:00 PM  

but sunny and sasi reply working for me