many to many relationship feilds value seletion throuh trigger in qlikivew

[aj0031724]

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?

[jonathandienst]

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 :

• select a KPI - only one (associated) group is possible
• select several KPIS - only the groups associated are possible
• select a group - only the KPIs in the group are possible
• select several groups - only the KPIs in those groups are possible.

Is there a specific reason that you need to do things differently?

[aj0031724]

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.

[splitcore]

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