Last 2 previous months on selection

[cedfoning]

Hello, please help, i have an issue. 

I have the following data. The user selected the month of February. 

Upon selection, he has the following data. 

	Stock at 20240131	Stock at 20240229
Code
1	8 732,000	7 859,000
2	6 395,000	5 610,000
3	1 399,000	1 186,000
4	2 154,000	1 893,000
5	6 731,000	5 711,000

I want to implement this table in Qlik sense. 
Each time the user selects a month, lets say 202402, we must have the result of the last day of the month selected on one column and the last day of the previous month on the other column.

[anat]

assuming you data source data like below:

id	month	sal
1	20230101	100
2	20230115	10
3	20230131

table1:

load id,month,sal from table;

VCM=monthend(max(month))

VPM=monthend(addmonths(max(month),-1))

curent month:sum({<month={'$(VCM)'}>}sal)

Pre month:sum({<month={'$(VPM)'}>}sal)

[cedfoning]

How can you get a monthend of a month ? 
is it not a monthend of a date ?

The rule is : when the user selects a month, whe should have the sum of sales of the last day of the month selected

[anat]

yes,monthend of a date

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

[cedfoning]

Ok i see. 
i tried but it's not weekend. 
When i select a month in a filter, your script doesn't work. 

	Stock au 20240229	Stock au 20240303
Code
1	8 732,000	7 859,000
2	6 395,000	5 610,000
3	1 399,000	1 186,000
4	2 154,000	1 893,000
5	6 731,000	5 711,000

In the dataset above, the user selected the month of february. 
the results shows then last day of the month selected and the last day of previous month depending on the selection