Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The :AND-Mode in listbox could be useful here. Otherway, perhaps could be using set analysis.
Dear,
i think you can use cross table concept.
can you share sample data file.
Thanks,
Mohammed Mukram
Can you attach sample to look where Column 1/2/3 coming from?
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
Qlikview is a Advanced Associative Engine. That means, It can do automatic when we use simply Count(Measure)
The :AND-Mode in listbox could be useful here. Otherway, perhaps could be using set analysis.
Hi Anil,
Data like below
sno | company | policy |
1 | fire | |
2 | accenture | accident |
3 | ibm | accident |
4 | wipro | accident |
5 | infosys | fire |
6 | hcl | fire |
7 | dell | fire |
8 | dell | accident |
9 | fire | |
10 | 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
What is the logic behind for last Count is 2? I know your intention but need to understand in your way
Hi Anil,
count 2 is how many company's we have both policy's.
Regards
Sathish
May be this?
=If(GetSelectedCount(policy) = 1, Count(policy),Count(Aggr(Count({<policy = {'fire', 'accident'}>} policy), policy)))