topic Re: Not able to display diffirence in QlikView

Not able to display diffirence

Thu, 28 Aug 2014 07:20:33 GMT

Hi Friends,

I am trying to take the difference of tow numbers in a straight table. I am getting errors.

Please see the attachment. Also I want to display the diffirence in premiums as a list box.

Please help

Anonymous — Thu, 28 Aug 2014 07:25:46 GMT

the sign "-" Shows that something is wrong.

how does your Expression Looks like. please Show it

Thu, 28 Aug 2014 07:26:13 GMT

can u provide what are those two numbers

if these are the two numbers then u can do diference like this

SISEpremium - OGIS premium in the expression part of Straight table

ashfaq_haseeb — Thu, 28 Aug 2014 07:27:08 GMT

HI,

In your difference Expression, write below code.

=column(1)-column(2)

Regards

ASHFAQ

MarcoWedel — Thu, 28 Aug 2014 07:27:29 GMT

please post example qvw.

maybe there is more than one combination of your subtracted values for a givden dimension combination.

regards

Marco

Thu, 28 Aug 2014 07:27:44 GMT

Inorder to display teh diffrerence in Listbox

better do the difference between those two fields in the script area and name it as Premium

and use that premiun as listbox

Thu, 28 Aug 2014 07:33:22 GMT

The two fields comes from diffirent tables.

Can i write a code like resident load where I can take the difference between two fields

MarcoWedel — Thu, 28 Aug 2014 07:47:01 GMT

depending of the relation between your tables there might be more than one combination. So you might need an aggregation (sum, min, max, ...)

jagan — Thu, 28 Aug 2014 07:48:00 GMT

Hi Pavan,

Try this expression using your expression captions

=[SISEpremium] - [OGIS premium]

Regards,

Jagan.