topic Re: set analysis in QlikView

set analysis

ahmedwank — Wed, 25 Nov 2020 16:16:04 GMT

hi all

i dont understand where is my mistake when i defined a very basic set analysis with a constraint in it

see picture attached

many thanks in advance

Re: set analysis

vishsaggi — Mon, 11 Mar 2019 01:00:34 GMT

You cannot give =1 when using a field with Total qualifier, it will be a syntax error. You may want to do like this

=Sum(TOTAL <[cat final]> {< [cat final] = {1} >} ligne)

Re: set analysis

jonathandienst — Mon, 11 Mar 2019 05:06:53 GMT

Or this (depending on exactly what the OP wants):

Sum({<[cat final] = {1}>} TOTAL ligne)