Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
In qlikview, I have a data base in that way, as below:
Status | Year | Product Category | CBU | Family | Jan | Fev |
FCST | CY | Cars | 1 | L | 29 | 34 |
FCST | CY | Cars | 1 | M | 67 | 64 |
FCST | CY | Cars | 1 | H | 14 | 22 |
FCST | CY | Cars | 2 | L | 9 | 9 |
FCST | CY | Cars | 2 | M | 7 | 9 |
FCST | CY | Cars | 2 | H | 5 | 7 |
MKT | CY | Cars | L | 1 | 1 | |
MKT | CY | Cars | M | 0 | 0 | |
MKT | CY | Cars | H | 11 | 21 |
I have a problem: I'd like to show all MKT volumes when I choose any CBU (1 and/or 2). But MKT appears as a "blank" CBU dimension
What should I do?
Regards
so this should be ok:
sum({$<CBU= >}Jan)
whatever value from CBU calculate sum