Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
How i can create an expression to define a Column Title based in a conditional.
Sample that i have tryed, but without success:
CROSSTABLE ([Brand], [Quantity], 2)
LOAD
F1 as PRODUCT,
BRAND1,
BRAND2,
IF(PRODUCT="TLB", BRAND3, OTHERS)
FROM....
Thanks for any reply
Danilo
Leonard,
I will try explain better;
- I need import or load one crosstable that have the fallowing information below:
Brand in one line
Products in colomns, side by side and above quantity's of sell's in number of units
So i have 3 informations: Brand, Products and Unit Qty's (CROSSTABLE).
WHEEL LOADER | GRANDER | DOZER | TLB | ||
BRAND1 | 10 | 6 | 5 | 3 | 25 |
BRAND2 | 8 | 2 | 6 | 7 | 20 |
BRAND3 | 7 | 9 | 12 | 3 | 14 |
As the example above
When i import this table as a CROSSTABLE, QlikView create 3 tables; Quantity, Product and Brand.
Using the way that we have tryed, the field BRAND with this conditional will be load in table Quantity, that is my problem.
The logic behide this is when the product be TLB so BRAND3 can be BRAND3, but if product not be TLB use OTHERS.
I hope that this time has achieved explain better..
Thanks