Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dataset having just months(from Jan to Dec)name but I want to create dates from month like (Jan : 1/1/2022 to 12/31/2022 ) and all dates from all months till (Dec: 1/1/2022 To 12/31/2022)..
CrossTable(month, sales, 2)
Info:
LOAD
"Business Area",
Product,
"44197" as Jan,
"44229" as Feb,
"44258" as March,
"44290" as April,
"44321" as May,
"44353" as June,
"44384" as July,
"44416" as Aug,
"44448" as Sep,
"44479" as Oct,
"44511" as Nov,
"44542" as Dec,
City
FROM [lib://Cross Table/Cross Table Data Set.xlsx]
(ooxml, embedded labels, table is Sheet1);
Hi, you are already loading 'dates' from this excel, just usually when loading dates from excel Qlik treats them as numbers, like 44197, 44229 etc., but with function date() you can convert them to date back. so date('44229') is actually '1/1/2021' etc. Modify your script so:
...LOAD
"Business Area",
Product,
date(44197) as Jan,
date(44229) as Feb, ...
But it shows date like Jan = 1/1/2021
Feb= 2/2/2021
Mar=3/3/2022 and so on.
and it not show sales column..
I want to show date like.....
Month Date Sales
Jan 1/1/2022
Jan 1/2/2022
Jan 1/3/2022
till
Dec 12/30/2022
Dec 12/31/2022
Refer this article
https://community.qlik.com/t5/Design/How-to-populate-a-sparsely-populated-field/bc-p/1470674