Immidate day before selected date range mesure value

[Anonymous]

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.

[#2]

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

[Anonymous]

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

DG

[#4]

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