topic Re: Qlik multiple selection issue in Water Cooler

Qlik multiple selection issue

SyedBasha — Wed, 29 Oct 2025 13:57:18 GMT

In qlikscript if my month is Apr 2020 my calculate date looking as May 01like start of may if my month is May 2020 calculate date is Jun 01 etc....but the actual problem is when i select both the months like April 2020 and May 2020 my calculate date is Jun 01 wise please help me on this

In script level only needed

Attached example screen shot

Re: Qlik multiple selection issue

Lisa_P — Wed, 29 Oct 2025 22:48:05 GMT

What is the script calculating this ?

Re: Qlik multiple selection issue

SyedBasha — Thu, 30 Oct 2025 03:22:12 GMT

In script level I want to show number(calculatedate- min(effectdate)) * net premium as Dailynetpremium

calculatedate script is (Date(Monthname(addmonths(max(Effectdate),1)),'YYYY-MM-DD')

calculatedate is creating a problem while i am selecting current month in UI getting a correct results but, while i am selecting multiple months the result is not getting correct, In calculatedate I want to create like this.

Re: Qlik multiple selection issue

SyedBasha — Thu, 30 Oct 2025 11:03:03 GMT

Single month selection → returns next month’s first date

- ✅ Multiple months → returns the latest selected month + 1

- ✅ Dynamic month handling for any year/month combination

Re: Qlik multiple selection issue

Lisa_P — Thu, 30 Oct 2025 23:07:36 GMT

Because you are looking at dynamic values based on selections, you will need to do dynamic calculation in the chart to display max(CalculatedDate) as a measure, to show the result you are looking for.

Re: Qlik multiple selection issue

SyedBasha — Wed, 05 Nov 2025 09:37:34 GMT

@qlikqlik @Qlik3 could you please help me on the above solution

Re: Qlik multiple selection issue

PrashantSangle — Wed, 05 Nov 2025 10:53:05 GMT

Script does not work in that way, in which way you are thinking now. Scripts are like SQL. It worked base on filter/where parameter you passed while writing script. Once Script run it load the required data in dashboard & on the top of that you can play with Set Analysis or front end function.

But if you want to pass the value from your selection in the front end to back end (Script) then create variable which hold that selection value & create Reload button on front end. So it will work something like

if you select Apr & Jun both month --> variable will hold max(month) --> Jun

then by Clicking on reload button you can use that value in backend script.

Hope that make sense.

Regards,

Prashant Sangle

Re: Qlik multiple selection issue

SyedBasha — Wed, 05 Nov 2025 12:34:20 GMT

Thanks for sharing Prashant, can you please share some examples