How to find out the missed items while applying filters

[#1]

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

[SunilChauhan]

information is not sufficient .you need to explore bit more

if possible you could load sample

you could also verify your data with database.

[sujeetsingh]

What you want to be done ?

What is correct as per your requirements?

[#4]

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.

[sujeetsingh]

No Krishna why dont you just create a sample and post

[jagan]

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.

[#7]

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.

[SunilChauhan]

Load *,

'Appliances - LG' as App,

'Japan' as Reg,

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

Resident Raw_Data

WHERE

index(ITEM,'LG')>0;

[#9]

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

[#10]

Hi

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