Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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

Best,

Sunny