topic Re: filter date in set analysis in QlikView

filter date in set analysis

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

Hi guys,

I have this expression inside an textfield:

=num(Sum({<date = {$(v_max_date)}, kind = {1}>}price), ' #.##0,00 €')

and the expression return me this error:

Error: Error in set modifier ad hoc element list: ',' or ) expected

but I don't understand where I've to add ',' or )

I've define v_max_date in this way =max(date)

Thanks.

fvelascog72 — Mon, 21 May 2018 09:23:57 GMT

Hi,

Try with:

=num(Sum({<date = {'$(v_max_date)'}, kind = {1}>}price), ' #.##0,00 €')

Saludos.

Anil_Babu_Samineni — Mon, 21 May 2018 09:35:05 GMT

I think yours is make sense. What is the wrong?

=num(Sum({<date = {$(=v_max_date)}, kind = {1}>}price), ' #.##0,00 €')

=num(Sum({<date = {'$(v_max_date)'}, kind = {1}>}price), ' #.##0,00 €')

shiveshsingh — Mon, 21 May 2018 09:50:43 GMT

PLease try this

=num(Sum({<date = {"$(v_max_date)"}, kind = {1}>}price), ' #.##0,00 €')

Anonymous — Mon, 21 May 2018 11:27:19 GMT

no one works, i've add the attachment at the main question

sunny_talwar — Mon, 21 May 2018 11:30:56 GMT

Try this

=Num(Sum({<date = {"$(=$(v_max_date))"}, kind = {1}>}price), ' #.##0,00 €')

Anonymous — Mon, 21 May 2018 12:52:08 GMT

Thanks a lot