topic Re: select possible and exclude set analysis in QlikView

select possible and exclude set analysis

Wed, 01 May 2013 09:24:00 GMT

Hello

I dont know if i am able to do this.

I have a Funnel chart where i have a count of companies from my listbox Milestone.

Can i include a value in my expression so i would get values from my listbox phases

I am thinking something like this?

=Count({$<DimSalesPhases.Milestone=e({$<DimSalesPhases.Milestone={'UKENDT'}>} DimSalesPhases.Milestone),

DimPotentialCustomers.RelationID=p({$<DimPotentialCustomers.RelationID={'11'}>} DimPotentialCustomers.RelationID) DimPotentialCustomers.Company)

So first im excluding a value from milestone (that works fine if i only have this) But next i want to include a valaue from another listbox - but i cant seem to figure out the expression?

Re: select possible and exclude set analysis

er_mohit — Wed, 01 May 2013 09:31:05 GMT

try this

Count({$<DimSalesPhases.Milestone=E({1<DimSalesPhases.Milestone={'UKENDT'}>}),

DimPotentialCustomers.RelationID=P({1<DimPotentialCustomers.RelationID={'11'}>})>}distinct DimPotentialCustomers.Company)

Re: select possible and exclude set analysis

Wed, 01 May 2013 09:33:43 GMT

count({$<DimSalesPhases.Milestone=E({<DimSalesPhases.Milestone={"UKENDT"}>}),

DimPotentialCustomers.RelationID=P({<DimPotentialCustomers.RelationID={"11"}>})>}distinct DimPotentialCustomers.Company)

Re: select possible and exclude set analysis

Gysbert_Wassenaar — Wed, 01 May 2013 09:43:11 GMT

Try:

=Count({$<[DimSalesPhases.Milestone]-={'UKENDT'},[DimPotentialCustomers.RelationID]={11}>} DimPotentialCustomers.Company)

This will exclude companies with milestone value UKENDT and include only customers with relationid 11.

...or are you looking for this perhaps:

=Count({$<[DimSalesPhases.Milestone]-={'UKENDT'}>+<[DimPotentialCustomers.RelationID]={11}>} DimPotentialCustomers.Company)

Re: select possible and exclude set analysis

Wed, 01 May 2013 09:48:39 GMT

That does not work - It marks read for ukendt to the last line.

However i dont think i was specific enough.

My Milestone consits of:

UKENDT

I want to exclude companies with milestone value UKENDT, but show all companies from A,B,C,D - and then i want to show all companies from value K in RelationID

Re: select possible and exclude set analysis

Wed, 01 May 2013 09:49:39 GMT

Yea something like the plus i think.. if that is adding the value to the others even though its from another list

Re: select possible and exclude set analysis

Wed, 01 May 2013 11:31:55 GMT

I can show what i get.

The first picture i have all my values but excluded UKENDT on DimSalesPhases.Milestone

Next i have ALL values from DimPotentialCustomers.RelationText - BUT what i want is, that i want to show only CLOSED (but together with my DimSalesPhases.Milestone)

IS that even possible??