topic Re: Date Format in QlikView

Date Format

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

Hello,

I have the format MM/DD/YYYY HH:MM:SS and i am trying to MM/DD/YYYY

I don't know why this is showing.

I tried like below

date(date#(First_StartTime,'MM/DD/YYYY HH:MM:SS'),'MM/DD/YYYY')

Re: Date Format

arulsettu — Tue, 30 Aug 2016 09:31:13 GMT

try this

date(Floor(First_StartTime)) as date

Re: Date Format

tresB — Tue, 30 Aug 2016 09:34:56 GMT

Try:

=date(date#(First_StartTime,'DD/MM/YYYY HH:mm:SS'),'MM/DD/YYYY')

Note: MM/DD -> DD/MM and MM(month)->mm(minutes)

OR,

simply,

Date(First_StartTime, 'MM/DD/YYY')

Re: Date Format

Anonymous — Tue, 30 Aug 2016 09:36:05 GMT

try to use lower case characters for time

= floor(date(date#(First_StartTime,'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY'))

Re: Date Format

Anil_Babu_Samineni — Tue, 30 Aug 2016 09:51:50 GMT

Rudolf, I am trying similar that, Nothing use. Have you checked my attachment.

Arul: in real data, It's work -- date(Floor(First_StartTime)) as First_StartTime

Does any other solution?

And i am adding qvw here as well, in that, 10/08/2016 got the max. This scenario i want to put Red as BG

Re: Date Format

sunny_talwar — Tue, 30 Aug 2016 10:04:13 GMT

You want to highlight 10/08/2016 like this?

Used a background expression:

=If(Rank([Dashboard Running]) = 1, LightRed())

Re: Date Format

Anil_Babu_Samineni — Tue, 30 Aug 2016 10:15:21 GMT

While I tried this. It's nor working

=If(Rank([Dashboard Running]) = 1, LightRed(),If(Rank([Dashboard Running]) = 2,Green(), Yellow()))

Re: Date Format

sunny_talwar — Tue, 30 Aug 2016 10:19:42 GMT

Are you looking to give different colors to each of the bar based on the Rank?

Re: Date Format

sunny_talwar — Tue, 30 Aug 2016 10:21:09 GMT

Try this:

=If(Rank([Dashboard Running], 1, 1) = 1, LightRed(), If(Rank([Dashboard Running], 1, 1) = 2,Green(), Yellow()))

Re: Date Format

Anil_Babu_Samineni — Tue, 30 Aug 2016 10:22:29 GMT

Seems that, But Here i want to show how many dashboards are running for each date. Which date is running more dashboards, Upto Three ranks then Yello

If(Rank(Sum(Sales)=1, Green(), If(Rank(Sum(Sales)=1, Violet(), If(Rank(Sum(Sales)=1, Pink(), Red())))

Re: Date Format

Anil_Babu_Samineni — Tue, 30 Aug 2016 10:26:06 GMT

Yes, Thanks Sunny. 10 also need to show different like blue then yellow? I am about to finish this

Re: Date Format

sunny_talwar — Tue, 30 Aug 2016 10:35:03 GMT

Try this:

=If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime)), LightRed(),

If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime), 2), Green(),

If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime), 3), Blue(), Yellow())))

Re: Date Format

Anil_Babu_Samineni — Tue, 30 Aug 2016 10:36:54 GMT

interesting, Thanks.

Re: Date Format

Anil_Babu_Samineni — Wed, 31 Aug 2016 18:11:02 GMT

Sunny, I have one more doubt.

Can you please have a look which i attached below.

Here, what i want to achieve is From sheet3 I have values for 19/07/2016 are 102

But, While i am trying Sheet2 Bar graph Why this is showing 128 for 19/07/2016. Can you please suggest me?

Re: Date Format

sunny_talwar — Wed, 31 Aug 2016 18:39:42 GMT

Because the Sheet3 expression seems to be distinct values per dimension. To get 102 on the chart, try this:

=Sum(Aggr([count of select], Dashboard))

=Sum(Aggr(Only([count of select]), Dashboard))

=Sum(Aggr(Avg([count of select]), Dashboard))

=Sum(Aggr(Sum(DISTINCT [count of select]), Dashboard))

Re: Date Format

Anil_Babu_Samineni — Wed, 31 Aug 2016 19:05:36 GMT

Yes, here why not showing values by date wise. And, I've tried that. Unfortunately, the dates are not showing good way. How to figure it out.

Re: Date Format

sunny_talwar — Wed, 31 Aug 2016 19:09:30 GMT

Looking to get this?

Expression:

=Sum(Aggr([count of select], Dashboard, TaskRunDates))

Re: Date Format

Anil_Babu_Samineni — Wed, 31 Aug 2016 19:14:01 GMT

Thanks for your time.

Re: Date Format

sunny_talwar — Wed, 31 Aug 2016 19:15:41 GMT

No problem at all Anil. I just recommend to start a new thread with new requirement in the future.

Thanks,

Sunny