Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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?

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

May be

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

View solution in original post

10 Replies
sunny_talwar

May be this

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

soniasweety
Master
Master
Author

it showing   all values like

12:00 AM   12:00 AM  only 

shiveshsingh
Master
Master

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
Master
Master
Author

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?

QlikCommunity_Thread_303645_Pic1.JPG

regards

Marco

rwunderlich

I would suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

sasiparupudi1
Master III
Master III

May be

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

View solution in original post

soniasweety
Master
Master
Author

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