Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please help me , how to resolve this issues.
Thanks.
Regards,
Ram
Please help me,