Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
elislopes261
Contributor
Contributor

Set Analiysis

How can I correct this set analysis?

 

count({<started_at+={2022},
[schemas.name] = {
'customer_acquisition'
, 'callwe_trusted'
, 'support_messages_temp'
, 'delighted_car_change'
, 'zendesk_chat'
, 'delighted_experience'
, 'drivercentral'
, 'cx'
, 'zendesk_trusted'
, 'customer_cx'
, 'twilio'
, 'customer_acquisition_tmp'
, 'amazon_connect'
, 'delighted_maintenance'
, 'utils_driver_central'
, 'amazon_connect_trusted'
, 'zendesk_ticket'}> or
<[schemas.name] = {
'rental'
, 'rental_historical'
, 'rental_photos'
, 'rental_production'
, 'rental_transition'
, 'rental_trusted'},
tables.name = {'drivers'}>},
query)

Labels (2)
3 Replies
Kushal_Chawda

@elislopes261  You have extra comma in set. remove it

count({<started_at+={2022},
[schemas.name] = {
'customer_acquisition'
, 'callwe_trusted'
, 'support_messages_temp'
, 'delighted_car_change'
, 'zendesk_chat'
, 'delighted_experience'
, 'drivercentral'
, 'cx'
, 'zendesk_trusted'
, 'customer_cx'
, 'twilio'
, 'customer_acquisition_tmp'
, 'amazon_connect'
, 'delighted_maintenance'
, 'utils_driver_central'
, 'amazon_connect_trusted'
, 'zendesk_ticket'}> or
<[schemas.name] = {
'rental'
, 'rental_historical'
, 'rental_photos'
, 'rental_production'
, 'rental_transition'
, 'rental_trusted'},
tables.name = {'drivers'}>},
query)

elislopes261
Contributor
Contributor
Author

Thank you!!

vinieme12
Champion III
Champion III

Also replace Or  with +

 

 

count({<started_at+={2022},
[schemas.name] = {'customer_acquisition'
,'callwe_trusted'
,'support_messages_temp'
,'delighted_car_change'
,'zendesk_chat'
,'delighted_experience'
,'drivercentral'
,'cx'
,'zendesk_trusted'
,'customer_cx'
,'twilio'
,'customer_acquisition_tmp'
,'amazon_connect'
,'delighted_maintenance'
,'utils_driver_central'
,'amazon_connect_trusted'
,'zendesk_ticket'}> +
<[schemas.name] = {'rental'
,'rental_historical'
,'rental_photos'
,'rental_production'
,'rental_transition'
,'rental_trusted'}
,tables.name = {'drivers'}>
} query)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.