topic Re: format issue in QlikView

format issue

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: format issue

sunny_talwar — Mon, 04 Jun 2018 09:08:59 GMT

May be this

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

Re: format issue

soniasweety — Mon, 04 Jun 2018 09:17:10 GMT

it showing all values like

12:00 AM 12:00 AM only

Re: format issue

shiveshsingh — Mon, 04 Jun 2018 09:58:26 GMT

Can you try this?

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

Re: format issue

soniasweety — Mon, 04 Jun 2018 12:18:20 GMT

sunny its not working

Re: format issue

sunny_talwar — Mon, 04 Jun 2018 12:19:30 GMT

Can you share two images

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

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

Re: format issue

MarcoWedel — Mon, 04 Jun 2018 22:42:44 GMT

Hi,

is this what you are looking for?

regards

Marco

Re: format issue

rwunderlich — Tue, 05 Jun 2018 01:53:30 GMT

I would suggest:

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: format issue

sasiparupudi1 — Tue, 05 Jun 2018 06:23:16 GMT

May be

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

Re: format issue

soniasweety — Tue, 05 Jun 2018 06:46:17 GMT

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

Re: format issue

soniasweety — Tue, 05 Jun 2018 06:46:37 GMT

thanks sasi its working fine