topic Re: 4 previous dates data and hours wise data in QlikView

4 previous dates data and hours wise data

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

Hi Group,

Could you please give me the solution to the below task

Actually i have one filter like day (in listbox) based on that chart can change and i should get previous 4 dates..for example if i can select april 10th in day field i should get the data for these dates apr9th,apr8th,apr7th apr6th

and one more question is : for eg i have sales data but i need sales per hour on apr09th

help me on the both the questions please

Re: 4 previous dates data and hours wise data

swuehl — Wed, 25 May 2016 17:23:01 GMT

To limit your date range, maybe something like

=Sum(

{<Date = {">=$(=Date(Max(Date)-4,'YourDateFieldFormat))<$(=Date(Max(Date),'YourDateFieldFormat'))"}>}

Amount)

Re: 4 previous dates data and hours wise data

sonysree88 — Wed, 25 May 2016 18:16:48 GMT

Thanks for reply ,i tried its not working still facing issue to get the previous dates and sales per hour wise

Let me know any another solutions

Re: 4 previous dates data and hours wise data

sunny_talwar — Wed, 25 May 2016 18:23:32 GMT

I would think that what Stefan provided should work for you, do you have a sample where you can show what is not right

Best,

Sunny

Re: 4 previous dates data and hours wise data

sonysree88 — Thu, 26 May 2016 06:23:34 GMT

Here am using Orderdate in date field

=Sum(

{<Date = {">=$(=Date(Max(Date)-4,'YourDateFieldFormat))<$(=Date(Max(Date),'YourDateFieldFormat'))"}>}

Amount)

Note: Date filed is date with time stamp can you give me the syntax like above with time stamp format date

Re: 4 previous dates data and hours wise data

swuehl — Thu, 26 May 2016 08:54:28 GMT

You can just use Timestamp() formatting function (well,basically Date() will work the same also) and an appropriate format code:

On Format Codes for Numbers and Dates

Re: 4 previous dates data and hours wise data

sonysree88 — Tue, 31 May 2016 17:16:04 GMT

Previous date are coming now but data is not correct means

for each date data is coming as same ( there is no difference)

Re: 4 previous dates data and hours wise data

swuehl — Tue, 31 May 2016 18:49:40 GMT

Could you upload a small sample QVW?

Or describe in detail what dimension(s) and expressions you are using in that chart, and how your data model with respect to these fields look like?

Re: 4 previous dates data and hours wise data

sonysree88 — Wed, 01 Jun 2016 10:32:17 GMT

Hi ,

Please find the screenshot and give me the solution

Re: 4 previous dates data and hours wise data

swuehl — Wed, 01 Jun 2016 13:40:25 GMT

The solution to what issue? I don't see that the results are the same as stated in your previous post.

And even if they were, I am unsure how I should help, still missing a more detailed description of the context and data model.

Re: 4 previous dates data and hours wise data

sonysree88 — Wed, 01 Jun 2016 17:46:54 GMT

Hi,

Can you please check this issue Here issues is if i select any date like 9/31/2012 then i need to display previous 4dates data like 8/30/2012,8/29/2012,8/28/2012,8/27/2012

eg 2: If i select 8/8/2012 then need to display previous 4 dates like 7/8/2012,6/8/2012,5/8/2012,4/8/2012 data in bar chart.

Note:I am attached Qvw files.Please check let me know the solution.

Thanks

Re: 4 previous dates data and hours wise data

swuehl — Wed, 01 Jun 2016 18:09:12 GMT

If you are interested in filtering dates, try creating a real date field from [Posted At] timestamp field.

Also check that all your input records are interpreted correctly as date / time.

Why don’t my dates work?

Get the Dates Right

Dates in Set Analysis

I've worked around some issues using an advanced search, but I would suggest that you create a consistent formatted date field with correctly interpreted values in your script, then use this field with my first suggested expression.