Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
In my SQL server database i have a field called Full_date. It is varchar(8) type.
to use this field in my QV application, i used Convert(date, Full_date) to convert into date data type.
Now, i made a date, month, year fields using the above field.
Month(Fulldate) as Month,
Year(Fulldate) as Year,
Day(Fulldate) as Date
I have created the Pivot table to show the current month sales, Previous month sales, current month target and previous month target.
My selections as below.
First i am selecting the Year, then ;month.
When i select month, the report should should show both current month and previous month sales and target.
When i use code "Month(Num(Month)-1)" is giving "Dec" month on the current selected month is "Feb". Actually it should give month "Jan" as my previous month.
Please help me in selecting the earlier month.
if i select "Jan" it should show "Dec"
if i select "Mar" it should show "Feb"
Regards
Srinivas
Are you sure that Convert(date, Full_date) converted your varchar values into correct dates?
Perhaps you can post a small Qlikview that demonstrates the problem.
Please post sample data .