Display last 31 days data

[Anonymous]

Hello experts,

I have chart in that one date dimension and multiple expressions are there. I want to display last 31 days from max of date.

Can any one suggest me how to do that one.

Regards,

Kumar

[karthikeyan1504]

Hi,

Try to restrict the 31 days from Dimension Limits option from bar chart properties.

Choose show only first 31 days, and sort the dimension in descending order.

Warm Regards,

Karthikeyan.

[sasiparupudi1]

Please post your application with sample data

[kavita25]

Your date format is wrong.

As in the screenshot ur date format is DD/MM/YYYY

So try using this:

[Time Full Date]={"$(=max(Date([Time Full Date],'DD/MM/YYYY'))-30)"

Hope it helps you!!

[Anonymous]

Hi Jagan,

As u suggested i modified the script and it  is displaying data. But i am still seeing all data. But it is not restricting to 31 days.

[jagan]

If you attach the sample file then it would easier to help you.

Regards,

Jagan.

[qlikviewwizard]

PPlease attach sample file.‌

[#8]

Hi Kumar, you can use couple of approaches for this requirement.

1. SET Analysis

    As per discussion, you have time stamp nn your date field. so please remove the time with floor function.

      Floor(DateTimeField) AS DateField --> QV generate number from this function & you can convert the number into date.

    Count( {<DateField={">=$(=Max(DateField)-31)"}>} DISTINCT VisitorID)

Note: the Max function also return number format & you need to explicitly convert number format into your data format if date field not in the number format.

2. Dimension Limits

     First on sort tab you need to sort the data based on your date dimension desc order. In the dimension limits tab Select check box for Restrict which values are displayed using the first expression. and show only first 31 values. the down side of this approach if some one change the sort order on UI it will change.

[Anonymous]

hi,

I am attaching qvd and model. Can anyone help me how to get it back only 31 days data only.

Thanks,

Kumar

[jagan]

Hi Kumar,

There is no matching records between the dim_visitor and dim_time tables, I think there is an issue with the key

field site_visit_start_datetime_key, check it in the script which is generating the QVD.

Hope this helps you..

Regards,

Jagan.