topic Re: Set Analysis - stupid question! in QlikView

Set Analysis - stupid question!

Mon, 30 Mar 2015 15:55:49 GMT

Hi all

I have 3 different companys and 3 different facts.

I want to show only 1 fact (Actual) in 1 company ... how can I do this?

To show all companies revenue I use this formula:

Num(sum({<Fact.Type = {'Sales'}>}Fact.Net_Rev_EUR), '#''##0.00')

To show only company PTX I tried this, but it gives me the wrong result, as it summarize the total in PTX:

sum({<Fact.Type = {'Sales'}> + <link_table.Company_Desc = {'PTX'}>}Fact.Net_Rev_EUR)

I want that only PTX is displayed...

Thanks for your help

Oliver

ramoncova06 — Mon, 30 Mar 2015 16:00:53 GMT

add the company desc into your set analysis

Num(sum({<Fact.Type = {'Sales'},link_table.Company_Desc = {'PTX'} >}Fact.Net_Rev_EUR), '#''##0.00')

Mon, 30 Mar 2015 16:03:01 GMT

Hi Ramon

Thanks for your help!

Cheers

Oliver

MK_QSL — Mon, 30 Mar 2015 16:03:26 GMT

sum({$<

Fact.Type = {'Sales'} ,

link_table.Company_Desc = {'PTX'}

>}Fact.Net_Rev_EUR)