Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
antoniotiman
Honored Contributor III

Re: Set Analysis not equal to Syntax

May be

Sum(If(Len(Trim(Flag))=0,Amount)

Not applicable

Re: Set Analysis not equal to Syntax

=Sum({$<[Flag]= e({1<id={'X'}>})>}[Amount])

try this

Not applicable

Re: Set Analysis not equal to Syntax

corrected one

try this please

=Sum({$<[Flag]= e({1<[Flag]={'X'}>})>}[Amount])

Highlighted
soloeeeoff
New Contributor III

Re: Set Analysis not equal to Syntax

Am I right ?

=Sum( {1- $<[Flag]={'x'}> } [Amount] )

Re: Set Analysis not equal to Syntax

Hi Cliff,

May be try,

=Sum({$<Flag ={'*'}-{'x'}>}[Amount])

lyeynant
New Contributor II

Re: Set Analysis not equal to Syntax

Hi , you need to change from  " -= "    to   " =- " and it will work.


=Sum({$<[Flag]=-{'x'}>}[Amount])

Re: Set Analysis not equal to Syntax

Indeed, it all depends on what should be the initial selection:

  • Flag -= {'x'}  Current selection minus those rows with Flag = x
  • Flag =- {'x'}  All rows with flag values (including those not selected), excluding those with Flag = x.

Set Analysis not equal to syntax thread234731.jpg

However, from the OP we cannot deduce in detail what is the initial situation...