topic Re: Cross table issue in QlikView

Cross table issue

saradhi_it — Thu, 22 Jun 2017 06:21:50 GMT

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

Re: Cross table issue

Anil_Babu_Samineni — Thu, 22 Jun 2017 06:23:59 GMT

Will you able to provide Mock excel to check the same?

Re: Cross table issue

MayilVahanan — Thu, 22 Jun 2017 06:27:16 GMT

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.

Re: Cross table issue

saradhi_it — Thu, 22 Jun 2017 06:28:47 GMT

send me your email id i will send sample excel file or you can create it the same in the excel and can try

Re: Cross table issue

Gysbert_Wassenaar — Thu, 22 Jun 2017 06:30:41 GMT

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])

;

Re: Cross table issue

Anil_Babu_Samineni — Thu, 22 Jun 2017 06:30:47 GMT

check your gmail, I've sent

Re: Cross table issue

saradhi_it — Thu, 22 Jun 2017 06:46:29 GMT

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

Re: Cross table issue

Gysbert_Wassenaar — Thu, 22 Jun 2017 06:55:49 GMT

Make sure you actually update the correct excel file (D:\Qlikview\XLS\vendors.xlsx) and save it before reloading the Qlikview document.