Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

sehow to write set analysis

=if((Datefield) < startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))

same  expression  i need in   set analysis

1 Solution

Accepted Solutions
MVP
MVP

Re: sehow to write set analysis

Hi,

Try this

=Sum({<Datefield={'<$(=startdate)'}, ABC = {'C'} >} XYZ) - Sum({<Datefield={'<$(=startdate)'}, ABC = {'D'} >} XYZ)

Regards,

Jagan.

3 Replies
Not applicable

Re: sehow to write set analysis

Hi,

if((Datefield) < startdate ,sum({<ABC ={'C','XYZ'}>}) - sum({<ABC ={'D','XYZ'}>}))

MVP
MVP

Re: sehow to write set analysis

Hi,

Try this

=Sum({<Datefield={'<$(=startdate)'}, ABC = {'C'} >} XYZ) - Sum({<Datefield={'<$(=startdate)'}, ABC = {'D'} >} XYZ)

Regards,

Jagan.

Not applicable

Re: sehow to write set analysis

Jagan

jagan  thank you  it is  working fine

Community Browser