Process cross table in qlikview

Sean_BI — Sat, 16 Nov 2024 19:31:56 GMT

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.

Re: Process cross table in qlikview

Brett_Bleess — Wed, 11 Dec 2019 15:48:29 GMT

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

topic Re: Process cross table in qlikview in QlikView

Process cross table in qlikview

Re: Process cross table in qlikview