Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If-Function / Simples Question

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

10 Replies
Not applicable
Author

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 LOADERGRANDERDOZERTLB
BRAND11065325
BRAND2826720
BRAND37912314

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