Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
claudio_reis_we
Partner - Contributor III
Partner - Contributor III

Set Analisys

Hi,

Can you help me please?

How to implement the script below on a set analysis?

select numcad

from r034fun

where tipcol =1

    and datadm <= '01/03/2016'

    and (sitafa = <> 7 or (sitafa=7 and datafa>='01/03/2016'))

Thanks!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

{

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa -= {7}>

+

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa = {7}, datafa ={">=01/03/2016"}>

}

View solution in original post

3 Replies
Not applicable

what is the dimension . is it num of cad?

swuehl
MVP
MVP

Maybe like

{

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa -= {7}>

+

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa = {7}, datafa ={">=01/03/2016"}>

}

claudio_reis_we
Partner - Contributor III
Partner - Contributor III
Author

Hi, Stefan!

It worked!

thanks!