Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Link table using set analysis

Hi,

I have following model:

modelo.jpg

$KeyFechaTicket is a key from master calendar and it has a comparative date 1 year before.

For example: 15/11/14 vs 16/11/13....03/03/16 vs 20/03/15....

I want to sum "Cantidad Items" using %KeyFechaComparación = [Fecha Ticket]. I try doing it using the following expression but doesn't work:

     sum({<%KeyFechaTicket=, [%KeyFechaComparación] = {[Fecha Ticket]} >} [Cantidad Items])

Anyone can help me?...

Thanks!

1 Reply

Re: Link table using set analysis

Would you be able to share a sample with the expected output to be able to help you out better here.

Best,

Sunny