How to select Previous month

konidena — Sun, 21 Feb 2016 05:48:59 GMT

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

Re: How to select Previous month

Gysbert_Wassenaar — Sun, 21 Feb 2016 11:26:52 GMT

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.

Re: How to select Previous month

Anonymous — Sun, 21 Feb 2016 12:45:57 GMT

Please post sample data .

topic Re: How to select Previous month in QlikView

How to select Previous month

Re: How to select Previous month

Re: How to select Previous month