Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Join Table problem

Hi Experts,

i have 2 tables as below screenshot.  for the actual data table, there is updated period and period , for the budget data just have period, i would like to analysis actual vs qty by month.

months comes from period with selected updated period. then i put one navigational panel to select updated period. however, this selection cause budget data filtered out. How could i implement this ? Please advise. Thanks.

2 Replies
Highlighted
Partner
Partner

Hello,

As per my understanding, you want to show period wise Actual and Budget Qty.

For that you can just load the tables and associate both the table on Period, Like done in attached QVF.

Regards,

Prashant

Highlighted
Creator
Creator

Thanks for your help.

i have check your qvf file, in this case the jan actual qty is 200. i would like to select updated period for example choose 2019-05, then display actual qty and budget qty.

expected result:  choose 2019-05

 period         actual        budget

Jan-2019     100            500

Feb-2019     101            501

Mar-2019    102             502

......

Dec-2019   0                  511