If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need to add one static DATE formatted value from one fixed cell of excel, into all rows under a particular column of a table which is loaded from another excel sheet into a table in Qlik Sense.
How can I do this?
Thanks and Regards.
first load the fact data lets call this table A , next load the column from the excel file lets call this table B . apply a join you will get the column added to the fact filled for all rows.
Dept, Region, Amt
FROM [LIB://<file name>]
the output will be Dept, Region, Amt, Trans_date