Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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