https://community.qlik.com/t5/QlikView/Syntax-on-set-analysis-instead-of-if-condition/m-p/1540349#M439391 generally it should be<BR />Sum({&lt;a unique field other than dimension ={"=COUNT(Dimension)&gt;$(vNumber)"}&gt;} XXXXXX)<BR /><BR />but anyways if you replace the variable with a number , let's say 5 , does it work? Wed, 06 Feb 2019 14:51:46 GMT pradosh_thakur 2019-02-06T14:51:46Z https://community.qlik.com/t5/QlikView/Syntax-on-set-analysis-instead-of-if-condition/m-p/1540346#M439390 <P>I need to calculate a KPI only if a dimension is greater than a number set in a variable</P><P>Sum({&lt;Dimension={"=COUNT(Dimension)&gt;$(vNumber)"}&gt;} XXXXXX)</P><P>but it doesn't work, i don't want to use if condition for performance troubles, is it possible?</P><P>Tks</P> Sat, 16 Nov 2024 04:32:36 GMT https://community.qlik.com/t5/QlikView/Syntax-on-set-analysis-instead-of-if-condition/m-p/1540346#M439390 canmarroig 2024-11-16T04:32:36Z https://community.qlik.com/t5/QlikView/Syntax-on-set-analysis-instead-of-if-condition/m-p/1540349#M439391 generally it should be<BR />Sum({&lt;a unique field other than dimension ={"=COUNT(Dimension)&gt;$(vNumber)"}&gt;} XXXXXX)<BR /><BR />but anyways if you replace the variable with a number , let's say 5 , does it work? Wed, 06 Feb 2019 14:51:46 GMT https://community.qlik.com/t5/QlikView/Syntax-on-set-analysis-instead-of-if-condition/m-p/1540349#M439391 pradosh_thakur 2019-02-06T14:51:46Z