topic Re: How to find out the missed items while applying filters in QlikView

How to find out the missed items while applying filters

Fri, 01 Aug 2014 05:51:45 GMT

Hi,

I have a situation where data is incorrect for particular month. Filter Criteria is Region as Japan, Application as LG below that we have 2 sub applications group as Customer Support and Oncall Support. While analysing using Tablebox by using Select fields, I got to know that I have a data for Customer Support, but not for Oncall Support. How to resolve this issue?

Could someone throw some insights on this?

Regards

Velan

Re: How to find out the missed items while applying filters

SunilChauhan — Fri, 01 Aug 2014 05:56:18 GMT

information is not sufficient .you need to explore bit more

if possible you could load sample

you could also verify your data with database.

Re: How to find out the missed items while applying filters

sujeetsingh — Fri, 01 Aug 2014 06:03:15 GMT

What you want to be done ?

What is correct as per your requirements?

Re: How to find out the missed items while applying filters

Fri, 01 Aug 2014 06:26:53 GMT

I want the data to be accumulated for both the groups, say for grp1=70 + grp 2=80 but am getting data only for Customer Support group. Hope this will give a clear picture.

Re: How to find out the missed items while applying filters

sujeetsingh — Fri, 01 Aug 2014 06:29:54 GMT

No Krishna why dont you just create a sample and post

Re: How to find out the missed items while applying filters

jagan — Fri, 01 Aug 2014 06:37:34 GMT

Hi Krishna,

It is good practice to attach sample data or Qlikview file and expected output, so that it would be easier for people in community to solve your question. Otherwise it would be difficult to answer you.

Regards,

Jagan.

Re: How to find out the missed items while applying filters

Fri, 01 Aug 2014 06:52:46 GMT

Hi,

Please find below the script in place for filter criteria. It should filter the data for the items LG_Customer_Support and LG_OnCallSupport under LG for specific month. But am getting only closed ticket numbers for 1st group.

Load *,
'Appliances - LG' as App,
'Japan' as Reg,
applyMap('BIRegion',Ticket_Site,'OTHERS') as Reg1
Resident Raw_Data
WHERE
"Owned by Group"='LG_SUPPORT_INBOUND' and index(ITEM,'LG')>0;

'Appliances - LG' as App,
applyMap('BIRegion',Ticket_Site,'OTHERS') as Reg,
applyMap('BIRegion',Ticket_Site,'OTHERS') as Reg1
Resident Raw_Data
WHERE
"Owned by Group"='LG_SUPPORT_INBOUND' and index(ITEM,'LG')>0;

Please let me know still you need some inputs.

Re: How to find out the missed items while applying filters

SunilChauhan — Fri, 01 Aug 2014 06:58:58 GMT

Load *,

'Appliances - LG' as App,

'Japan' as Reg,

applyMap('BIRegion',Ticket_Site,'OTHERS') as Reg1

Resident Raw_Data

WHERE

index(ITEM,'LG')>0;

Re: How to find out the missed items while applying filters

Fri, 01 Aug 2014 07:07:57 GMT

Thanks Chauhan. Let me have a try and will comeback if I need something.

Re: How to find out the missed items while applying filters

Mon, 04 Aug 2014 08:08:21 GMT

I have a Straight table where it shows the opened Ticket Numbers for every month. for example July-159, Aug-53 as last week total nos. but today it's showing less data for both the months. Please someone could look into this and throw some insights. Expression for that measures in St table. is

if(isNull(sum(IncidentsOpened)),0, sum(IncidentsOpened))

Regards

Velan