topic Re: Set Analysis with AND, OR, and Ignore Fields Criteria in QlikView

Set Analysis with AND, OR, and Ignore Fields Criteria

spetushi — Sat, 13 Oct 2018 15:39:03 GMT

Hello All,

I am interested in finding the appropriate set analysis syntax to do the following:

(Field1 = 'stringA' OR Field2 = 'stringA') AND Field3 = 'stringC' AND DateField >= StartDate AND DateField <= EndDate, ignore selection in fields: Field4, Field5, Field6

Thanks,

Sokol

Re: Set Analysis with AND, OR, and Ignore Fields Criteria

vishsaggi — Sun, 14 Oct 2018 03:01:23 GMT

What is the Aggr function you are using I mean sum or count? So try like below

and make sure your startdate and endate are in same format as your DateField. Else use Date() function around start and end dates with formatting.

= Sum({<Field1 = {'stringA'}, Field2 = {'stringB'}>*<Field3 = {'stringC'}>*< DateField = {">=$(=Date(StartDate))<=$(=Date(EndDate))"} >} YourMeasurefield)

Re: Set Analysis with AND, OR, and Ignore Fields Criteria

rubenmarin — Sun, 14 Oct 2018 11:44:08 GMT

Hi, maybe:

{<Field1={'stringA'},Field3={'StringC'},DateField={">=$(=Date(StartDate))<=$(=Date(EndDate))"}>,Field4,Field5,Field6>

+<Field2={'stringA'},Field3={'StringC'},DateField={">=$(=Date(StartDate))<=$(=Date(EndDate))"}>,Field4,Field5,Field6>}

or maybe:

{<Field1={'stringA'}>+<Field2={'stringA'}>*<,Field3={'StringC'},DateField={">=$(=Date(StartDate))<=$(=Date(EndDate))"}>,Field4,Field5,Field6>}

Re: Set Analysis with AND, OR, and Ignore Fields Criteria

spetushi — Tue, 16 Oct 2018 13:04:31 GMT

The Aggr function it's a Count