topic Re: Formula does not work in App Development

Formula does not work

Daniel1908 — Fri, 09 Apr 2021 10:21:26 GMT

Hello Together,

The below formula doese not work.
Can you help?

=Count({<[Price-3]-={[Price-1]+[Price-2]},[ReturnLabel]={'A*'}>})Material&Shorttext)

Count all Price-3 which do not match with the total of Price-1 + Price-2 and have Return Label beginning wich A*.

Kind Regards,
Daniel

Re: Formula does not work

Fernando_Fabregas — Fri, 09 Apr 2021 12:36:07 GMT

Hi Daniel.

For searches you must use double quotes:

[ReturnLabel]={"A*"}

Full explanation here:

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-modifiers.htm

Regards, Fernando

Re: Formula does not work

Daniel1908 — Fri, 09 Apr 2021 13:15:34 GMT

Hi Fernando,

Thanks for the reply.
Unfortunately the formula does still not work.

Do you have any ideas?

Kind Regards
Daniel

Re: Formula does not work

Fernando_Fabregas — Mon, 12 Apr 2021 13:25:25 GMT

Hi Daniel. Try this:

Count({<[ReturnLabel]={'A*'}>}) if([Price-3]<>{[Price-1]+[Price-2], Material&Shorttext ) )

I think this way it will work fine, but you won't get the best performance because if () evaluates each row in the table one by one.

Regards.

Re: Formula does not work

MayilVahanan — Mon, 12 Apr 2021 13:36:13 GMT

Hi @Daniel1908

Try like below, bring flag field in script

Load *, if([Price-3]<>{[Price-1]+[Price-2], 1, 0) as Flag from ursourcetable;

In front end, try like below

=Count({<Flag ={1},[ReturnLabel]={"A*"}>})Material&Shorttext)

Re: Formula does not work

Daniel1908 — Mon, 12 Apr 2021 14:45:49 GMT

It shows Error in expression. Count takes 1 parameter.

Re: Formula does not work

Daniel1908 — Mon, 12 Apr 2021 15:19:33 GMT

Formula now shows OK after taking away the bracket before "if".

But does not show any values.

Kind Regards

Re: Formula does not work

Daniel1908 — Mon, 12 Apr 2021 15:21:11 GMT

Hi Mayil,

it seems to work.

Do you know how to exclude the differnce of the prices at the decimal places?

Kind Regards,
Daniel

Re: Formula does not work

MayilVahanan — Tue, 13 Apr 2021 02:17:57 GMT

HI @Daniel1908

might be Try like below

Load *, if([Price-3]-([Price-1]+[Price-2]) > 1, 1, 0) as Flag from ursourcetable;

Re: Formula does not work

Daniel1908 — Tue, 13 Apr 2021 14:57:01 GMT

Hi Mayil,

unfortunately I just get 0 Values, but the formula shows still OK.

if("Price-3"-"Price-1"+"Price-2",'>1''1','0') as Flag, (from ursourcetable)

=Count({<Flag ={1},[ReturnLabel]={"A*"}>})Material&Shorttext)

Any Idea?

Kind Regards,
Daniel

Re: Formula does not work

MayilVahanan — Tue, 13 Apr 2021 14:53:14 GMT

Try like below

if("Price-3"-("Price-1"+"Price-2") >1,1,0) as L1Vergleich

=Count({<L1Vergleich={1},[ReturnLabel]={"A*"}>})Material&Shorttext)