Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
ramya_beginner
Contributor

Always select 1 value filter

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?

4 Replies
Highlighted

Re: Always select 1 value filter

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?

Highlighted
ramya_beginner
Contributor

Re: Always select 1 value filter

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!

Highlighted

Re: Always select 1 value filter

Something along these lines? Hierarchy in QlikView

Highlighted
ramya_beginner
Contributor

Re: Always select 1 value filter

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;