Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table "A" and a table "B", both containing dates.
Table A
Date | Country | Forecast qty |
dd.mm.yyyy | x | 33 |
Table B
date | country | |
dd.mm.yyyy | x |
The actuals are the number of lines in table B and the forecasts are the quantities per line in its correspondent field in table A. I can use the month and country to link both tables but I cannot get to put "forecasts" (sum) and "actuals" (count of lines in table B) in the same table to be able to compare them in graphs.
I am new to Qlik Sense so your help is very appreciated!
Thank you
The data does not have to be in the same table, the tables will be linked by common fieldname(s). From the chart perspective, it's one big joined table.
Make a chart, for example a table chart. Use Month and Country as Dimensions.
1st Measure: Sum([Forecast qty])
2nd Measure: You will need field unique to TableB to count. If you have a such a field, you can get the count of lines in TableB as "count(fieldname)". If you don't have a suitable field, you can create one in the load script by adding the following to the Load statement for TableB.
1 as Actual
and then "sum(Actual)" in your chart.
The data does not have to be in the same table, the tables will be linked by common fieldname(s). From the chart perspective, it's one big joined table.
Make a chart, for example a table chart. Use Month and Country as Dimensions.
1st Measure: Sum([Forecast qty])
2nd Measure: You will need field unique to TableB to count. If you have a such a field, you can get the count of lines in TableB as "count(fieldname)". If you don't have a suitable field, you can create one in the load script by adding the following to the Load statement for TableB.
1 as Actual
and then "sum(Actual)" in your chart.