Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
claudio_reis_we
Partner
Partner

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
Partner
Author

Hi, Stefan!

It worked!

thanks!