count wise highest values (If multiple values have height count it will display the all values)
Hi All,
Scenario 1:
This is in Qliksense.
I have field like,
LOAD * INLINE [ A_Name, C_Value, C_Flage ANA, BAC, Yes ANA, ICC, NO ANA, SPC, Yes ANA, DAC, No ANA, PPC, Yes ANA, BAC, NO ANA, ICC, Yes ANA, SPC, No ANA, DAC, Yes ANA, PPC, NO ANA, BAC, Yes ANA, ICC, No ANA, SPC, Yes ANA, DAC, NO ANA, PPC, Yes ANA, BAC, No ANA, ICC, Yes ANA, SPC, NO ANA, DAC, Yes ANA, BAC, No ANA, ICC, Yes ANA, SPC, NO ANA, DAC, Yes ANA, PPC, No ANA, BAC, Yes ANA, ICC, NO ANA, BAC, Yes ANA, ICC, No ANA, SPC, Yes AND, BAC, NO AND, ICC, NO AND, SPC, Yes AND, DAC, No AND, PPC, Yes AND, BAC, NO AND, ICC, Yes AND, SPC, No AND, DAC, NO AND, PPC, NO AND, BAC, Yes AND, ICC, No AND, SPC, Yes AND, DAC, NO AND, PPC, Yes AND, BAC, No AND, ICC, Yes AND, SPC, NO AND, DAC, Yes AND, BAC, Yes AND, ICC, Yes AND, SPC, Yes AND, DAC, Yes AND, PPC, No AND, BAC, Yes AND, ICC, NO AND, BAC, Yes AND, ICC, NO AND, SPC, NO ];
This is my data
Here Count is only C_Flage is 'Yes'
BAC DAC ICC PPC SSP ANA 4 3 3 2 4 AND 4 2 3 2 3
If I calculating the that displaying the in this way. These are C_Flage is 'Yes'
My Requirement is
I want to display the top value count of each values. if two c_values count is same it will display the two values, if 3 , three values displayed like that,
I used firstsortedvalue , Aggr function , Number ways i tryed,But not working , it 's displaying single value only , I want Max count is same it will displayed all vales.
required out put is-
Out Put:
A_Name C_Value
ANA BAC,SSP
AND BAC
Scenario 2:
I have Qliksense dashboard in that numbers reports are there like -
Filters, KPI's, Bar charts, Pie charts, Table Box , Line chart like that.
In that If i select the values in table box , It won't reflected in others metrics, If i select any value in filters or Pie charts or any charts it will reflect in Table box.
