Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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