Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Partner - Champion III
Partner - Champion III

Hi,

Try this

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

Regards,

Jagan.

View solution in original post

3 Replies
Not applicable
Author

Hi,

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

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try this

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

Regards,

Jagan.

Not applicable
Author

Jagan

jagan  thank you  it is  working fine