topic Re: Why filter one field in SetAnalysis do not efect sum other field same table? in QlikView

Why filter one field in SetAnalysis do not efect sum other field same table?

yanivvl0 — Mon, 12 Feb 2018 13:01:02 GMT

hi , i have a table (MAIN) of books readers , and i sum the measure (books) ,

i need to sum only those that the indicator (read) = 0 , so i use SetAnalysis : = sum ( {$< read={0} >} books ) ,

the problem is that when i select read <> 0 it supose to show me NOTHING - BUT i steel see the same numbers !?

another thing , when i use = sum ( if( read=0, books ) ) it work OK ..

am i missing something ? THANKS .

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

Anil_Babu_Samineni — Mon, 12 Feb 2018 13:08:09 GMT

Not entirely, But assumption you may try this?

=Sum({$< read={"=Sum(read)<>0"} >} books)

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

sunny_talwar — Mon, 12 Feb 2018 13:16:35 GMT

Try this

=Sum({$<read *= {0}>} books)

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

sunny_talwar — Mon, 12 Feb 2018 13:20:09 GMT

Read about this here:

Implicit Set Operators

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

yanivvl0 — Mon, 12 Feb 2018 13:20:13 GMT

hi Anil, that was quik , YEA - its ok , i fix it to Sum({$< read={"=Sum(read)=0"} >} books) - the " = " sign ,

can you tell me whats wrong with my expression ?

THANKS!!!

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

Anil_Babu_Samineni — Mon, 12 Feb 2018 13:30:28 GMT

Sure, read = {0} returns where read = 0 {That means, It calculates without aggregate} where Sum(read)=0 {It will aggregate each row where cells are common for each orient}

Does this helps?

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

yanivvl0 — Mon, 12 Feb 2018 13:34:00 GMT

GREAT HELP!

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

yanivvl0 — Mon, 12 Feb 2018 14:00:06 GMT

hi Sunny , very helpfull !! Always learns professional material from you THANKS!

Re: Why filter one field in SetAnalysis do not efect sum other field same table?

sunny_talwar — Mon, 12 Feb 2018 14:02:21 GMT

No problem at all