Process cross table in qlikview

[Sean_BI]

Dear Experts -

I have a cross tab (refer to attachment) which needs to be processed in qv.

The challenge is for 'Products for months' column has Jul, Aug, Sep, Oct ( as the products for month as merged) and then the cell continue for 'Sub products for months' column has Jul, Aug, Sep only (note Oct is not there).

when i process using cross tab transformation, the file is read as below.

the script is considering 'Products for months' as having Jul, Aug, Sep, Oct, Nov, Dec, Jan, because qv is unable to understand when the Month end for 'Products for months'. 

Appreciate early response.

Thanks'

Sean.

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post, I think it should help you on this one!

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Regards,
Brett