topic If Condition in QlikView

If Condition

sat_tok52 — Sun, 28 Feb 2016 15:27:30 GMT

Hi Guru's,

I need a calculated dimension as per my requirement ,but I trying below expression it's not working . I wanted to see divided amount and minus amount under one column called AMT.

=If(Sum(AMT)/Sum(TOTAL AMT) or

Sum(AMT)-Sum(TOTAL AMT),'AMT'))

In any help.

-Sateesh

Re: If Condition

robert_mika — Sun, 28 Feb 2016 15:36:16 GMT

If takesn condition

so your first argument must have = or is (isnull,istext...)

At the moment the first argumet is not equal to anything

(Sum(AMT)/Sum(TOTAL AMT) or

Sum(AMT)-Sum(TOTAL AMT

must be like

if(Sum(AMT)/Sum(TOTAL AMT)=... or

Sum(AMT)-Sum(TOTAL AMT=.... ,'AMT....

Re: If Condition

swuehl — Sun, 28 Feb 2016 15:37:06 GMT

Could you elaborate a bit more what you are trying to achieve?

Above won't work for multiple reasons, but maybe there is a totally different approach possible?

For example, why not just use two expressions to show the divided amount and the difference of amounts?

Re: If Condition

mithilesh17 — Sun, 28 Feb 2016 15:38:22 GMT

Hi,

Requirement unclear. Is AMT and TOTAL AMT are two different fields?

Provide sample app.

Regards,