topic Re: Always select 1 value filter in QlikView

Always select 1 value filter

Anonymous — Wed, 24 Feb 2016 01:39:01 GMT

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?

Re: Always select 1 value filter

sunny_talwar — Wed, 24 Feb 2016 01:46:34 GMT

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?

Re: Always select 1 value filter

Anonymous — Wed, 24 Feb 2016 15:47:45 GMT

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!

Re: Always select 1 value filter

sunny_talwar — Wed, 24 Feb 2016 15:53:40 GMT

Something along these lines? Hierarchy in QlikView

Re: Always select 1 value filter

Anonymous — Wed, 24 Feb 2016 16:55:31 GMT

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;