Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
villafuerte
Partner Ambassador
Partner Ambassador

Double Cross Table

Hi,

I'm trying to handle a cross table with several levels, it looks like this:

error loading image

Any ideas?

Thanks!

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Well, unfortunately, CROSSTABLE load doesn't hand;e this situation "out of the box" ...

So, if your data structure is fairly static, You can separate it into 2 CROSSTABLE loads - first, load only Budgets, and then, load only Actuals.

Otherwise, you need to read each column separately and identify separately what belongs to what - quite messy, I have to say...