Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

17 Replies
antoniotiman
Master III
Master III

Hi,

See Attachment.

Regards,

Antonio

soniasweety
Master
Master
Author

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
Master III
Master III

Like this

soniasweety
Master
Master
Author

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

antoniotiman
Master III
Master III

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

What is Your expected output ?

soniasweety
Master
Master
Author

Hi,

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

antoniotiman
Master III
Master III

Can You show Your expected output ?

soniasweety
Master
Master
Author

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

antoniotiman
Master III
Master III

I don't see Your app and result.

Can You provide sceenshot ?