topic Re: Two expressions with two dates in set analysis not working in QlikView

Two expressions with two dates in set analysis not working

j_nlucas — Sat, 16 Nov 2024 05:05:37 GMT

I've got a pivot table with dimensions: Week and Weekday for a selected year. I have to show the sales for each week and week day for the selected year, and for the previous year.

I've got a calendar that gives me the fields week number and weekday and a fact table with the sales. In the calendar, for each date I also have the same date for the same week and weekday for the previous year.

I can get it work for the current year, but when I write the expression for the last year, I get 0 for all.

Expression for current year: sum(ImporteSinIVA)

Expression for last year: Sum({<Año, Mes, Trimestre, DiaSemana, Semana, Fecha, MismoDiaAA={'$(vMismoDiaAA)'}>}ImporteSinIVA).

Here, variable vMismoDiaAA = Date(Max(MismoDiaAA), 'DD/MM/YYYY'). The field "MismoDiaAA" is in the calendar, and it's calculated for each day, as stated above. The variable is defined with the sign "=" at the beginning.

I have attached the table should it help.

Any idea?

Re: Two expressions with two dates in set analysis not working

hopkinsc — Fri, 30 Nov 2018 14:14:18 GMT

Hi, does it work if you use an = in the variable in the set analysis (before the varibale name)..

MismoDiaAA={'$(=vMismoDiaAA)'}>}ImporteSinIVA)

Re: Two expressions with two dates in set analysis not working

Wlad_Masi — Fri, 30 Nov 2018 21:42:20 GMT

Have you checked this link?
https://community.qlik.com/t5/Qlik-Design-Blog/Quotes-in-Set-Analysis/ba-p/1471824

Double quotes looks to be a good option here.

Re: Two expressions with two dates in set analysis not working

j_nlucas — Mon, 03 Dec 2018 08:29:36 GMT

Hi Hopkinsc, thanks for your reply.
Unfortunately it doesn't work. However
Sum({<Año, Mes, Trimestre, DiaSemana, Semana, MismoDiaAA={"=$(vMismoDiaAA)"}>}ImporteSinIVA) will show the me same amount as the current date.

As you see, I have now changed the single quotes to double quotes, and added the = at the left of the "$". But I'm not there yet

Re: Two expressions with two dates in set analysis not working

j_nlucas — Mon, 03 Dec 2018 08:30:23 GMT

Thank you for that link.

I downloaded the latest version and tried the double quotes, but it's not working.