Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Relationship between table Qlikview

If I have the following tables

Discounts:

      Date_Discount      Rate

      2014.04.01              10

      2014.04.02              11

      2014.04.05                9

      2014.04.06              12

Sales:

      Sales_Date           Amount

       2014.04.01            100

       2014.04.02            120

       2014.04.03              80

       2014.04.04              90

       2014.04.05              95

       2014.04.06             110

       2014.04.07             125

How could i get the following table?

      Sales_Date        Amount        Rate

       2014.04.01            100             10

       2014.04.02            120             11

       2014.04.03              80             11

       2014.04.04              90             11

       2014.04.05              95               9

       2014.04.06            110             12

       2014.04.07            125             12

1 Solution

Accepted Solutions
Highlighted
Not applicable

Its pretty much the same what enrique has done. Instead I have done a left join.

View solution in original post

7 Replies
Highlighted
Master II
Master II

is this ?

P00.png

Highlighted
Not applicable

Tables.jpg

Highlighted
Not applicable

Its pretty much the same what enrique has done. Instead I have done a left join.

View solution in original post

Highlighted
Not applicable

My question is: How do union

Where there is no discount for the Sales_date, take off immediately above.

Highlighted
Not applicable

Thank you, Suraj

Highlighted
Not applicable

Thank you, Enrique.

I did not see the attachment

Highlighted
Not applicable

How could i do something more dynamic?