Always select 1 value filter

[Anonymous]

Hi

I have a 2 filters 1 Group and 2 API each group has its set of API , I want API to be as always one value selected filter ,

the issue I am facing is .. I set the default values with a group and an API selected when the application is opened,but if  the want to change the group to something else it does not allow because the already selected API does not belong to the any other groups.. how do I fix this?

[sunny_talwar]

I would think that the selection in API would clear out as soon as your click on a contradicting Group. Is this not happening by default? Do you have on select or change triggers?

[Anonymous]

it is , but the problem is sometimes User might not be sure which API to pick inorder to select the related Group function , can I have a Tree List or some other option which indicates which API belongs to which Group?

Thanks!

[sunny_talwar]

Something along these lines? Hierarchy in QlikView

[Anonymous]

This is quite confusing , so I just have 2 fields Group and API .. is there a simpler way to do this?

How do I join this with rest of the data model ? does this have to be in a separate load ?

FCIBridges:
Load * inline
[
FCIQuarter,FCIBridge
'2015 Q4',0.20
'2016 Q1',0.20
'2016 Q2',0.20
'2016 Q3',0.20
'2016 Q4',0.20
];


Table1:
load
"Date",
"Group",
if(Isnull("FC"),'0',"Count")as "Count1",
if(Isnull("FC"),'0',"FC")AS "FC1",
"Count",
"FC",
"Service API",
"FCI",
"RYG_FCI",
"RYG_TP99",
"SLA_FCI",
"SLA_TP99",
"TP50",
"TP90",
"TP99",
"TP999"
;

SQL SELECT *
FROM "Operational Xcellence: Services Time Series bjznuur2b";

ServiceTimeSeries:
Load
if(month(ServiceTimeSeries.Date)='Aug',(year(ServiceTimeSeries.Date) + 1) & ' Q1',
if(month(ServiceTimeSeries.Date)='Sep',(year(ServiceTimeSeries.Date) + 1) & ' Q1',
if(month(ServiceTimeSeries.Date)='Oct',(year(ServiceTimeSeries.Date) + 1) & ' Q1',
if(month(ServiceTimeSeries.Date)='Nov',(year(ServiceTimeSeries.Date) + 1) & ' Q2',
if(month(ServiceTimeSeries.Date)='Dec',(year(ServiceTimeSeries.Date) + 1) & ' Q2',
if(month(ServiceTimeSeries.Date)='Jan',(year(ServiceTimeSeries.Date) + 0) & ' Q2',
if(month(ServiceTimeSeries.Date)='Feb',(year(ServiceTimeSeries.Date) + 0) & ' Q3',
if(month(ServiceTimeSeries.Date)='Mar',(year(ServiceTimeSeries.Date) + 0) & ' Q3',
if(month(ServiceTimeSeries.Date)='Apr',(year(ServiceTimeSeries.Date) + 0) & ' Q3',
if(month(ServiceTimeSeries.Date)='May',(year(ServiceTimeSeries.Date) + 0) & ' Q4',
if(month(ServiceTimeSeries.Date)='Jun',(year(ServiceTimeSeries.Date) + 0) & ' Q4',
if(month(ServiceTimeSeries.Date)='Jul',(year(ServiceTimeSeries.Date) + 0) & ' Q4')))))))))))) as FCIQuarter,
if(WildMatch("Group",'*Payments*'),'Payments',
if(WildMatch("Group",'*Payroll*'),'Payroll',"Group")) as FCIGroup,
'' as Status,
*;

LOAD
"Date" as "ServiceTimeSeries.Date",
"Group",
"Service API" as "Function",
("Count1") as "RequestCount",
("FC1") AS "FCCount",
("Count") as "RequestCount_All",
("FC") AS "FCCount_All",
"FCI",
"RYG_FCI",
"RYG_TP99",
"SLA_FCI",
"SLA_TP99",
"TP50",
"TP90",
"TP99",
"TP999"
resident Table1;



Drop Table Table1;