How to manage calender selection?

[Anonymous]

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

[prma7799]

use Calendar object for this

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

[Anonymous]

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

[Wlad_Masi]

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.

[ahmar811]

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

[prma7799]

Try this

change listbox using calendar

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

[Anonymous]

Can You Please attach the application

[ahmar811]

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

[Anonymous]

Hi

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 )

[ahmar811]

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