Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I got two tables "Sales" and "Production". I just have keyfldmaterial same.
I want to filter date, example: 2020, sales (Validfrom) and production (Postdate) in 2020 must be show.
They are seperated 2 table on screen, but i want managed those dates with one mastercalendar.
"sales" (Validfrom) not equal "production" (Postdate)
Can you help me, thanks 🙂
LOAD doctype,
docnum,
validfrom,
quantity,
grandtotal,
keyfldmaterial;
[Sales]:
SELECT "doctype",
"docnum",
"validfrom",
"quantity",
"grandtotal",
"keyfldmaterial"
FROM "SALES";
LOAD
keyfldmaterial,
potype,
prdorder,
quantity,
postdate;
[Production]:
SELECT
"keyfldmaterial",
"potype",
"prdorder",
"quantity",
"postdate"
FROM "Production";
You could take a look at HICs good old blog post on Canonical Date.
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
Hi again, i solve my problem shoter way.
I defined one keyflddate for mastercalendar and other two tables. its worked for me.
example;
[Production]:
"postdate" as keyflddate;
[Sales]:
"validfrom" as keyflddate;