Cross table issue

[saradhi_it]

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

[Anil_Babu_Samineni]

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

[MayilVahanan · Accepted solution]

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.

[saradhi_it]

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

[Gysbert_Wassenaar]

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

;

[Anil_Babu_Samineni]

check your gmail, I've sent

[saradhi_it]

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

[Gysbert_Wassenaar]

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