topic If-Function / Simples Question in QlikView

If-Function / Simples Question

Wed, 06 Jul 2011 14:50:31 GMT

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

If-Function / Simples Question

IAMDV — Wed, 06 Jul 2011 20:24:24 GMT

Danilo,

Please try this...

IF(PRODUCT='TLB', 'BRAND3', 'OTHERS') AS PRODUCT

Cheers - DV

If-Function / Simples Question

Wed, 06 Jul 2011 20:38:33 GMT

D V,

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 =/

[FlashAux]:

CROSSTABLE([Brand], [Quantity],2)

LOAD

F1 AS [Product],

makedate($(ano),$(mes)) AS [Date],

[BRAD 1],

BRAND2,

IF(Product='TLB','BRAND3', 'OTHERS') as Product,

BRAND4,

BRAND5,

BRAND6,

BRAND7,

BRAND8,

BRAND9,

OTHERS

FROM [Flash Market\Flash$(var).xls]...

Tks

Danilo

If-Function / Simples Question

IAMDV — Wed, 06 Jul 2011 20:44:17 GMT

What is the error message? Instead of Product, have you tried using F1 in the function condition. I mean you can't use the alias name with the same load script.

Cheers - DV

If-Function / Simples Question

Wed, 06 Jul 2011 20:57:57 GMT

DV,

as you have oriented, i need use F1 instead of Product.

But another problem was appeared.

The field was loaded into different table. For it should have been loaded at Brands along with Brand4, 5 and so on, but was loaded in Quantity.

What to do?

Thanks again

If-Function / Simples Question

Wed, 06 Jul 2011 21:05:52 GMT

Danilo,

I think what you want to do is change your If statement to: IF(F1 = 'TLB','BRAND3','OTHERS') as Brand3.

F1 has yet to be renamed to Product when your if statement executes so you need to reference it as it is in the excel file.

Now, does Brand1-9 exist as fields in the xls file?

If-Function / Simples Question

IAMDV — Wed, 06 Jul 2011 21:07:44 GMT

Is it possible for you to share the QV document?

Cheers - DV

If-Function / Simples Question

IAMDV — Wed, 06 Jul 2011 21:09:24 GMT

I think Leonard is right. figures crossed that should resolve the issue.

Cheers - DV

If-Function / Simples Question

Wed, 06 Jul 2011 21:18:35 GMT

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

([Brand], [Quantity],2)

------

CROSSTABLE(if([Brand]='BRAND3' and [Product]='TLB', 'BRAND3','OTHERS'), [Quantity],2)

Tks again

-----

If-Function / Simples Question

Wed, 06 Jul 2011 21:57:00 GMT

Could you provide a better layout of your source data at least for us? Also, what end result are you trying to achieve? What is the purpose of having each Brand in its own column within the source data? Could that be better accomplished in the chart itself?

If-Function / Simples Question

Thu, 07 Jul 2011 18:48:34 GMT

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