Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
CrossTable(c_date, Curr_value, 3)
LOAD 'box' AS PRODUCT,
[ Name],
Flag,
[201701],
[201702],
[201703],
[201704],
[201705],
[201706]
FROM
(ooxml, embedded labels, table is [abc]);
i have problem in the above cross table ,when ever the data updated in the excel after refreshing in qlikview i can't see the data again i create new table for this
Regards
saradhi
Hi
Try like this
CrossTable(c_date, Curr_value, 3)
LOAD 'box' AS PRODUCT,
FROM
(ooxml, embedded labels, table is [abc]);
Edit: And also, check the path once.
Will you able to provide Mock excel to check the same?
Hi
Try like this
CrossTable(c_date, Curr_value, 3)
LOAD 'box' AS PRODUCT,
FROM
(ooxml, embedded labels, table is [abc]);
Edit: And also, check the path once.
send me your email id i will send sample excel file or you can create it the same in the excel and can try
Do you update the data in the excel file or do you add data in the excel file? If you add data in new columns in the excel file, for example data for 201707 then you also need to change the load script. Perhaps like works:
CrossTable(c_date, Curr_value, 3)
LOAD
'box' as PRODUCT,
*
FROM
(ooxml, embedded labels, table is [abc])
;
check your gmail, I've sent
hi Gysbert
the data will be updated in the excel but when i refresh the dashboard the updated was not reflecting in the dashboard i will try u r solution
Regards
saradhi
Make sure you actually update the correct excel file (D:\Qlikview\XLS\vendors.xlsx) and save it before reloading the Qlikview document.