topic Re: Immidate day before selected date range mesure value in QlikView

Immidate day before selected date range mesure value

Anonymous — Tue, 12 Feb 2013 00:43:29 GMT

Hi All,

I have a business scenaio like this.

If I select a date range 8/1 to 8/5, I should be able to show them min(selected date range)-1 ie 7/31 date's value. I have used set expression like below it is not working .Any thoughts on this ?.

='Only Selection Previous Day Sum:'&

Sum({$<business_date = {"=$(=Min(business_date)-1)"}>} Sales)

QVW File has been attached.

Re: Immidate day before selected date range mesure value

Tue, 12 Feb 2013 06:17:16 GMT

Hi,

Create a variable MinDate. Expression is "=Min(business_date)-1"

and create text box like with this expression "=Sum({$<business_date = ,business_date = {'$(=MinDate)'}>} Sales)"

and don't forget to set date format for variable in document properties

find attachment

Hope its will help

Re: Immidate day before selected date range mesure value

Anonymous — Tue, 12 Feb 2013 18:50:19 GMT

Hi Karthik,

In the attached qvw it is working fine. I did same changes in my orignal document also but I am always getting 0 is there any other setting I need to correct?.

Find the attached qvw file(business_date_issue.qvw) in my original post which I am playing with..

Thanks

Re: Immidate day before selected date range mesure value

Wed, 13 Feb 2013 04:43:05 GMT

Hi,

There I found 2 issues in your qlikview.

First ,you have to total "SALES" instead of "Vehicle_TNA".

Second, You are using selection of calenderdate instead of business date. If you want to select calenderdate means, you should use

calenderdate also in Set expression.

Please find corrected attachment.

Hope its helps

Karthik