topic how create a calculated dimension in QlikView

how create a calculated dimension

Wed, 08 Dec 2010 06:08:15 GMT

Actually we have to create a calculated dimension in that list box.in our database there are 2 diff. fields namely "Invoice Quantity" and "Contract Quantity" in two diff. tables.we want to show the calculated dimension (Contract Quantity - sum(Invoice Quantity) ) as "Contract Status" so that it can work on individual item seperately.and we also want to asign two values in the list box "Contract Status" namely "PENDING"(if "Contract Status">0) else "COMPLETED".

how create a calculated dimension

renjithpl — Wed, 08 Dec 2010 06:27:58 GMT

Hi,

Just try in your load script something like this,

Load

If(([Contract Quantity]-Sum([Invioce Quantity]) >0, 'PENDING', 'COMPLETED') as [Contract Status]

From

.......abc.QVD

Please let me know if this is not what you are looking for.

Regards

Ranjit

how create a calculated dimension

Fri, 01 Jul 2011 15:50:13 GMT

Hi itsouvik.

You already have the answer.

In the dimensions tab you can find the Add Calculated Dimension button.

In the text box just enter:

=IF([Contract Status]>0, 'PENDING', 'COMPLETED')

Hope this help.

Regards