Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
KPI TABLE STRUCTURE:
SectorUtilizationKPI SectorUtilizationKPIGroup
HUA Uplink Load Percentage Load
HUA Downlink Load Percentage Load
HUA CS Traffic (AMR) Traffic
HUA Avg. #HSDPA Users Traffic
HUA Avg. #HSUPA Users Traffic
HUA HSDPA DL Volume ( MB) Volume
HUA Interactive HSDPA DL Volume ( MB) Volume
HUA Interactive HSUPA DL Volume ( MB) Volume
HUA HSUPA User 10ms TTI Throughput (kbps) Throughput
HUA HSUPA User 2ms TTI Throughput (kbps) Throughput
Dear team,
I have one multibox with these tow feids.
I nned to achive something like below THROUGH TRIGGER.
a) select ONE KPI -->resulting in selection of ASSOCIATED KPIGROUP
B)SELECT MULTIPLE KPI'S--> RESULTIMNG IN SELECTION OF MULTIPLE ASSOCIATED KPIGROUP
C)SELECT ONE KPI GROUP-> RESULTING IN SELECTION OF MULTIPLE ASSOCIATED KPIS
D)SELECT MULTIPLE KPIGROUP--->RESULTING in SELECTION OF MULTIPLE ASSOCIATED KPIS
e) nothing IS SELECTED--> NO SELECTION.
Can you please guide/advise?
If the data model is properly designed (with the correct association between KPIs and groups), then there should be no need for triggers as QV will automatically perform the selections :
Is there a specific reason that you need to do things differently?
Dear Jonathan,
Yes we have a condition to display chart only if one Kpi group is selected and at least one Kpi of the group .
""
currently, if the user filters to one KPI, the KPI graph is not displayed until the user select KPI group.
since only one KPI is selected, the graph should work.
it should also work if several KPIs are selected from the same KPI group.
KPI filter should affect the KPI Group filter, and pass the test of the graph that checks if the KPIs are from the same group. ""
Currently if you select one KPI assocoiate KPI group appears in white ->What I nned is to autoselect the GROUP as well to populate the chart .
Hope I am able to explain my nned.
Hi Avinash
From your explanation it does sound like your data is not linking properly as Jonathan also suggested... If the data links properly, the moment you select a KPI Associate Qlikview should automatically select the associated KPI group (It should turn green not stay white).
I don't think a trigger would work here as there are conditions that it would have to be able to look at like a "conditional trigger" if that makes sense.
Maybe use set analysis and conditional show in your chart expressions perhaps to force the selections depending on what the user selects?
Regards