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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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!

Labels (1)
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...

Ask me about Qlik Sense Expert Class!