Thanks for your reply, but not is this...
Look my complete code...if you see any problem, please tell-me.
ps.: without conditional, loads run =/
F1 AS [Product],
makedate($(ano),$(mes)) AS [Date],
IF(Product='TLB','BRAND3', 'OTHERS') as Product,
FROM [Flash Market\Flash$(var).xls]...
Unfortunally i can't share the QV file, because not is mine..
But the problem now, is:
My conditional was filling the table Quantity insteat of Brand.
I tryed change this:
CROSSTABLE(if([Brand]='BRAND3' and [Product]='TLB', 'BRAND3','OTHERS'), [Quantity],2)
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..