how to achive both columns data we have in some other column data using filter.

[satheshreddy]

Hi Experts,

I have below data..

Company1	Company2	Company3
A1	D1	A1
B1	E1	D1
C1		B1

here my filters like below.

  Filter  

A1

NON A1

once I click A1I need to see Company1 column data and when I click NON A1 I need to see Company2 data.

when am going to select NON A1 and A1 I need to see what ever we have both columns data in company3 column data.

How we can Achieve this

Regards

Sathish

[mdmukramali]

Dear,

i think you can use cross table concept.

can you share sample data file.

Thanks,

Mohammed Mukram

[Anil_Babu_Samineni]

Can you attach sample to look where Column 1/2/3 coming from?

[satheshreddy]

Hi Anil,

as of now I don't have Qlikview software

I will explain one more way

I have policy types like below

fire, accident.

here am creating one filter like

filter

fire

accident

when I click fire I need to see how many company's are have fire policy that company's count I need 

same way when we click accident I need to see how many company's have accident policy.

here one query

normally when we select both we will get hole data.

but I need like below

when I select both I need count (company's) what ever we have both Policy's company's.

.

Regards

Sathish

[Anil_Babu_Samineni]

Qlikview is a Advanced Associative Engine. That means, It can do automatic when we use simply Count(Measure)

[tresesco · Accepted solution]

The :AND-Mode in listbox could be useful here. Otherway, perhaps could be using set analysis.

[satheshreddy]

Hi Anil,

Data like below

sno	company	policy
1	google	fire
2	accenture	accident
3	ibm	accident
4	wipro	accident
5	infosys	fire
6	hcl	fire
7	dell	fire
8	dell	accident
9	facebook	fire
10	facebook	accident

filter

Filter

fire

accident

when I select fire I need out put like below

count(company)

5

when I select Accident I need out put like below

count(company)

5

when I select both fire and accident I need  count like below

count(company)

2

Regards

Sathish

[Anil_Babu_Samineni]

What is the logic behind for last Count is 2? I know your intention but need to understand in your way

[satheshreddy]

Hi Anil,

count 2 is how many company's we have both policy's.

Regards

Sathish

[Anil_Babu_Samineni]

May be this?

=If(GetSelectedCount(policy) = 1, Count(policy),Count(Aggr(Count({<policy = {'fire', 'accident'}>} policy), policy)))