topic Re: How to show data starts on? in QlikView

How to show data starts on?

qlikviewforum — Tue, 15 Mar 2016 13:13:26 GMT

I am using the below expression to show the starting date of the data if the period goes back before the period starts. So the below expression worked perfectly.

If the data exists for the selected date then as per the selected date, date should be visible. What changes is required to achieve the 2nd requirement. Please help!

date(Min({<Period=>}Period), 'MM/DD/YYYY')

Re: How to show data starts on?

brijesh1991 — Tue, 15 Mar 2016 13:27:18 GMT

Sorry to say, but clear explanation will help us to flash inputs. Would be happy to have an example also.

Re: How to show data starts on?

sunny_talwar — Tue, 15 Mar 2016 13:41:31 GMT

So the Minimum date should only be visible if you have data available for a selected date? Is that your requirement?

May be this:

If(Sum(FieldName) > 0, Date(Min({<Period>}Period), 'MM/DD/YYYY'))

Re: How to show data starts on?

qlikviewforum — Tue, 15 Mar 2016 13:47:21 GMT

If the user selects 07/01/2013 in the Calendar and data exists only from 07/01/2014, it should show 07/01/2014 since the data only exists from 07/01/2014. So the above expression worked as per this.

Now if the user selects 08/01/2014 in the Calendar it should show 08/01/2014 since the data exists for the selected date.

Hope the requirement is clear now.

Re: How to show data starts on?

qlikviewforum — Tue, 15 Mar 2016 13:55:03 GMT

What is "FieldName" here?

Sorry if I have not explained the requirement clearly. I have explained it again. Please check and let me know.

Re: How to show data starts on?

qlikviewforum — Thu, 17 Mar 2016 08:11:03 GMT

Any update from anyone on this?

Re: How to show data starts on?

brijesh1991 — Thu, 17 Mar 2016 09:07:14 GMT

Sum({$<Period={'$(=Min(Period))'}>}Field) //Where your period is in num format; convert it to date if require.

Re: How to show data starts on?

qlikviewforum — Thu, 17 Mar 2016 09:24:17 GMT

Thanks for your response.

I think requirement is still not clear. I need to show the starting date of the data against each row in a straight table. What you have suggested will do sum(Field) for the Min(Period).

date(Min({<Period=>}Period), 'MM/DD/YYYY')

If the user selects 07/01/2013 in the Calendar and data exists only from 07/01/2014, it should show 07/01/2014 since the data only exists from 07/01/2014. So the above expression worked as per this.

Now if the user selects 08/01/2014 in the Calendar it should show 08/01/2014 since the data exists for the selected date.

If the requirement is still not clear please let me know.

Re: How to show data starts on?

avinashelite — Thu, 17 Mar 2016 09:31:41 GMT

some thing like this

if(getfieldselection(Period)<date(Min({<Period=>}Period), 'MM/DD/YYYY'),date(Min({<Period=>}Period), 'MM/DD/YYYY'),Period)

Re: How to show data starts on?

jonathandienst — Thu, 17 Mar 2016 09:39:34 GMT

Perhaps:

=Date(RangeMax(Min({<Period=>} Period), Period), MM/DD/YYYY')

Re: How to show data starts on?

qlikviewforum — Thu, 17 Mar 2016 10:16:21 GMT

Thanks for your response.

I have already tried this but it is not working whenever the Period is selected in the dashboard. It is regarding '-' but it does works when there is a selection.

Re: How to show data starts on?

qlikviewforum — Thu, 17 Mar 2016 10:16:49 GMT

That's perfect. Thank you so much.

Re: How to show data starts on?

qlikviewforum — Thu, 24 Mar 2016 11:25:58 GMT

Sorry Jonathan I have misunderstood the requirement earlier so I am coming back on that.

I have input box to enter the Trending days, based on the value in the input box it displays data in the chart. for example if the input value is 10 then in the chart it display data for max(date) to last 10 days. if there is any date selected in the calendar then it displays it display 10 days data from selected date.

Imagine for a source if the 03/23/2015 and selected date range is 01/01/2015 to 12/31/2015 then expected output is 03/23/2015.

If the selected date range is 06/01/2014 to 07/01/2015 then expected output is 03/23/2015 since data is starting from 03/23/2015

If the selected data range is from 03/29/2015 to 03/29/2015 then expected output is 03/29/2015.

So if the date range goes back to 03/23/2015 then we should display 03/23/2015,

If the date range goes after 03/23/2015 then we should display the selected. i,e 03/29/2015 if the date range is 03/29/2015 to 03/29/2015

Hope the requirement is understandable. If not please let me know.