topic Re: How to manage calender selection? in QlikView

How to manage calender selection?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want when I select Year as ' 2018' , Month as 'Jan and feb' and Date as '1st to 27th'. I should get total sales for 2018, for entire jan (31 days) and feb (27 days) ie. total sales for 58 days .

How to do that ?

Please help

Re: How to manage calender selection?

prma7799 — Wed, 28 Feb 2018 11:29:46 GMT

use Calendar object for this

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Slider_Object.htm

Re: How to manage calender selection?

Anonymous — Thu, 01 Mar 2018 03:38:45 GMT

By using calendar object I can implement the following but I want by using List box object can I implement the following?

Re: How to manage calender selection?

Wlad_Masi — Thu, 01 Mar 2018 03:48:52 GMT

If you select data in the field day from 1 to 27, it will consider 2018 Jan from 1 to 27 and 2018 Feb from 1 to 27.
The best way to achieve it would be using a calendar object, without using it, the best way would be not selecting the days, or having filter panes as start month and start day as well as end month and end day.

Re: How to manage calender selection?

ahmar811 — Thu, 01 Mar 2018 04:29:06 GMT

Hi Kaul,

Please find some field level trigger for your requirement :

1- Year=max(Year)

2- Month = '("'&Concat({<Date={">=$(=Date(Addmonths(max(Date),-1),'DD-MM-YYYY'))<=$(=max(Date))"}>}Month,'"|"')& '")'

3- Date = '("'&Concat({<Date={">=$(=Date(Addmonths(max(Date),-1),'DD-MM-YYYY'))<=$(=max(Date))"}>}Date,'"|"')& '")'

I also attached qvw application for your help,I hone it will help you....

Regards

Ahmar

Re: How to manage calender selection?

prma7799 — Thu, 01 Mar 2018 04:29:11 GMT

Try this

change listbox using calendar

https://community.qlikview.com/thread/176411

Re: How to manage calender selection?

Anonymous — Thu, 01 Mar 2018 04:46:00 GMT

Can You Please attach the application

Re: How to manage calender selection?

ahmar811 — Thu, 01 Mar 2018 05:03:07 GMT

I already attached the application please find Test.qvw file.

Re: How to manage calender selection?

Anonymous — Thu, 01 Mar 2018 06:14:10 GMT

Here the trigger is working But my requirement is different. I want when I select 2018,Jan ,Feb ,1 to 27th ) then I should get Total No. of days in chart under 2018 as 58.

(58 because jan has 31 days and feb has 27 days )

Re: How to manage calender selection?

ahmar811 — Thu, 01 Mar 2018 07:35:43 GMT

Put below expression on Sales expression to calculate your sales

=sum({<Date={">=$(=Date(MonthStart(AddMonths(max(Date),-1)),'DD-MM-YYYY'))<=$(=Date(max(Date),'DD-MM-YYYY'))"},Year=,Month=>}Sales)

I also attached qvw file for more details

Regards

Ahmar

Re: How to manage calender selection?

Anonymous — Thu, 01 Mar 2018 07:51:36 GMT

But total no. of days should be seen as 58 in chart , so should i change the expression on total no. of days?

Re: How to manage calender selection?

Anonymous — Thu, 01 Mar 2018 07:53:38 GMT

I have following expression for sales

=num(sum({<year= {"$(=Max(year)-1)"}>} [inv value]/Sales_INR_Unit),'#,##0.0')

i have following expression for total no. of days

=num(count({< year = {"$(=Max(year)-2)"}>}DISTINCT Sold_Date),'#,##0.0')

Re: How to manage calender selection?

ahmar811 — Thu, 01 Mar 2018 09:15:56 GMT

if you have following expression for sales

=num(sum({<year= {"$(=Max(year)-1)"}>} [inv value]/Sales_INR_Unit),'#,##0.0')

"Date" is your date field which you consider as Calendar Date.

should be replace by below expression

=num(sum({<Date={">=$(=Date(MonthStart(AddMonths(AddYear(max(Date),-1),-1)),'DD-MM-YYYY'))<=$(=Date(AddYear(max(Date),-1),'DD-MM-YYYY'))"},Year=,Month=>}[inv value]/Sales_INR_Unit),'#,##0.0')

If you have following expression for total no. of days

=num(count({< year = {"$(=Max(year)-2)"}>}DISTINCT Sold_Date),'#,##0.0')

should be replace by below expression

=num(Count(DISTINCT {<Date={">=$(=Date(MonthStart(AddMonths(AddYear(max(Date),-2),-1)),'DD-MM-YYYY'))<=$(=Date(AddYear(max(Date),-2),'DD-MM-YYYY'))"},Year=,Month=>}Sold_Date),'#,##0.0')

I hope this will help you

Regards

Ahmar