topic Re: Expression issue in QlikView

Expression issue

harjedalskok — Thu, 15 Oct 2015 07:34:52 GMT

!Hi

im trying to show a admin fee for our subcontrators,

Ive got the correct expression for showing with the dimension Order, meaning the expression calculate how much the subcontrator fee is per order.

if(fkMountingPricelistID = '12', (sum(orderpriceamount * '0.2') + '100'), (sum(orderpriceamount * '0.2') + '260'))

Then ive made another diagram table, where i want to use the dimension subcontrator, to show the total for each subcontrator.

ive tryed this, but i dont get the correct numbers.

if(fkMountingPricelistID = '12', (sum(UTmonteringspris*0.2) + (Count(OrderId*100))), (sum(UTmonteringspris*0.2) + (Count(OrderId*260))))

anyone that can point me in the right direction.

Thx alot in advance.

/André

Digvijay_Singh — Thu, 15 Oct 2015 07:38:54 GMT

Not sure though but try Sum(If.... instead of If(Sum..you are using currently.

avinashelite — Thu, 15 Oct 2015 07:50:21 GMT

Try like this:

if(fkMountingPricelistID = '12', (sum(UTmonteringspris)*0.2) + (Count(OrderId)*100), (sum(UTmonteringspris)*0.2) + (Count(OrderId)*260)

)

harjedalskok — Thu, 15 Oct 2015 07:58:30 GMT

Thx for fast answer

When using above and I make selection of ONE subcontrator i have now a dif of 320, dont get why.

avinashelite — Fri, 16 Oct 2015 05:12:51 GMT

can you please share your app

jonathandienst — Fri, 16 Oct 2015 05:25:42 GMT

This would be the syntactically correct version of your first statement:

=if(fkMountingPricelistID = 12, (sum(UTmonteringspris * 0.2) + 100), (sum(UTmonteringspris * 0.2) + 260))

harjedalskok — Fri, 16 Oct 2015 05:42:14 GMT

Sure, ive upload the file.

Hope it can give u some idea, there are to table, the totals are not equal.

/André