Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

TimePeriod

Hi all,

I have a two  tables one is main table, one is SLA table

so I need to map the data based on type and task status I need to show the numbers . attached excel is the sample data

I explained with example in sheet1

can anyone suggest the way to achieve this?

Thanks

Sony

Tags (2)
17 Replies
antoniotiman
Honored Contributor III

Re: TimePeriod

Hi,

See Attachment.

Regards,

Antonio

soniasweety
Contributor III

Re: TimePeriod

thanks for your attempt Antonio .  But  that is not my expected result. it is showing all the tickets

but I need only the ticket status value is greater than main table data rest it should not be shown in table.

Could guide on that way?

example: SLA table

   

Order

ZAA - OS (Configure  )


12960010800086400M-57600

   Main table 

MM15343678OrderSCTASK5415502ZAA - OS (Configure  )MediumOpen

612078

like30000

in above  record elopse time in main table is greater than Sla table status  Medium  so it is displaying   but if it is less than that it should not be displayed in table:

instead of 612078   if you put 30000   still the ticket is showing.

thanks

Sony

antoniotiman
Honored Contributor III

Re: TimePeriod

Like this

soniasweety
Contributor III

Re: TimePeriod

thanks Antonio but what is the difference between in your first attachment ? nd second?

antoniotiman
Honored Contributor III

Re: TimePeriod

I'm sorry, I don't understand Your request.

What is Your expected output ?

soniasweety
Contributor III

Re: TimePeriod

Hi,

in my original app am getting  duplicate values I need distinct how to use distinct in the exp?

antoniotiman
Honored Contributor III

Re: TimePeriod

Can You show Your expected output ?

soniasweety
Contributor III

Re: TimePeriod

whatever you have done is correct . but in my app it is each duplicate numbers

antoniotiman
Honored Contributor III

Re: TimePeriod

I don't see Your app and result.

Can You provide sceenshot ?