topic simple(?) question in QlikView

simple(?) question

Tue, 11 Aug 2009 16:19:33 GMT

hi everyone.

pls look at the file I've attached.

I have only two columns one as budget_type and the other is the vale of it.

I want to add a new record that her budget_type will called "profit" and her value will be:

zzxx-mmkk (170-150) =20 , I want it to be calculate in the script itself.

how can I do that? is it possible to add records based on other recordes in the same dimension ?

thanks a lot

David

AW:simple(?) question

Tue, 11 Aug 2009 16:50:06 GMT

I don´t see the sense of your request.

Why do want to create a new record for profit in script and not in a table or via variable? When you´ve got more than two values, how should you decide what values should be subtract?

simple(?) question

Tue, 11 Aug 2009 18:29:07 GMT

hi,

see the new file I've attached.

for each company I have only two values in the budget_type dimension. (the mmkk and the zzxx)

And for each company I want to add a new value called profit.

The users want to select a record name profit (which is a record in the dimension budget_type ) and see the value of it (calculate as zzxx-mmkk )

What are my options if I am not doing it over the script?

thanx,

David

AW:simple(?) question

Tue, 11 Aug 2009 18:45:58 GMT

Ok, i see. You can do it with:


profit:
LOAD
company,
sum(IF([budget_type]='zzxx', [value])) - sum(IF([budget_type]='mmkk', [value])) AS profit
RESIDENT data
GROUP BY company;

See attached file.

Regards.

simple(?) question

Tue, 11 Aug 2009 19:22:24 GMT

almost...almost...

But you gave me a direction.

I told you its simple.........

I meant to this.

(see attachment)

thanx again