Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Two expressions with two dates in set analysis not working

Hi

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? 

 

 

 

 

Labels (2)
4 Replies
Partner
Partner

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

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

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

?

Support
Support

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

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.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Highlighted
Partner
Partner

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

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
Partner
Partner

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

Thank you for that link.

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