format issue

[soniasweety]

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?

[sunny_talwar]

May be this

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

[soniasweety]

it showing   all values like

12:00 AM   12:00 AM  only 

[shiveshsingh]

Can you try this?

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

[soniasweety]

sunny its not working

[sunny_talwar]

Can you share two images

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

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

[MarcoWedel]

Hi,

is this what you are looking for?

regards

Marco

[rwunderlich]

I would suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[sasiparupudi1 · Accepted solution]

May be

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

[soniasweety]

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