Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?

10 Replies
soniasweety
Master
Master
Author

thanks sasi its working fine