topic Add column in report directly in QlikView

Add column in report directly

Mon, 03 Jan 2011 12:51:37 GMT

Hi All,

Can we add a filed/column directly to our pivot report as Measure. Its not in our data model. It will be as on user demand.

Add column in report directly

deepakk — Mon, 03 Jan 2011 12:58:11 GMT

hi Ashwin,

I don't think you can add any data or filed if you don't have it in your data model.

Add most of fields in at script level so user can add it on fly. This is again only possible if you have

QV Enterprise server.

Another way around would be to write a macro code to add the fields to respective objects.

Add column in report directly

Mon, 03 Jan 2011 13:16:41 GMT

Hello Deepak,

Thanks for your fast reply.

Yaar even after using macro is it possible to attach a filed to report as a measure which is not linked to any of the related fields.

I used a excel file but was not getting any filed to linked it.

Add column in report directly

suniljain — Mon, 03 Jan 2011 13:24:50 GMT

Never Possible. You can display field as expression which is exist in data modelling .

Add column in report directly

deepakk — Mon, 03 Jan 2011 13:29:00 GMT

hi Ashwin,

You need to link the fields else you will not get a correct figure. Ask the user there might be some link.

In there current scenario they might be using some link to view it. Even a vlookup in excel requires a proper link to work. So check out with the concern person.

Add column in report directly

Mon, 03 Jan 2011 13:48:41 GMT

Dear Deepak and Sunil,

Please find the below data. Here Measure are first calculated column from data model. Date is dimension as Nov -10. Now AOP is coming from a external excel sheet which where only 1 filed is present i:e AOP which user change daily from Internet data.

Hope you got my problem !!! is it possible that AOP comes accoring to follwing measure and we can calculate Variance.

Total			Variance (Nov'10 - AOP)
"Measures"	Nov-10	AOP	Variance (Nov'10 - AOP)
Rentals	86.5	79.1	7.40
Surcharge	31.6	29.2	2.37
Intrest	54.9	49.9	5.03
deposite	47.5	38.7	8.78
Cash	46.6	44.1	2.45
Creadit	0.6	0.8	-0.18
Folow	8.1	6.2	1.95
DGTRE	2.4	3.0	-0.57
SCRT	160.2	142.7	17.46

Add column in report directly

Mon, 03 Jan 2011 14:24:57 GMT

Hello ,

Plzzz reply its urgent

if some one can suggest any method to do it.

Add column in report directly

suniljain — Mon, 03 Jan 2011 14:33:53 GMT

ashwin,

this scenarion not possible.

Add column in report directly

deepakk — Tue, 04 Jan 2011 04:55:19 GMT

hi Ashwin,

Its a complex situation and i have small queries. Does this calulated values for measures for the month of NOv-10 is coming from same table.

if yes then try to create the field using the logic whcih you have mention in the expression.

eg: for Rental the expr might be : If(AccountCode ="909',Amount). so in back end create a field

: If(AccountCode ="909','Rental') as Expenses

And used the Expenses as dimesion.

or if they are coming from different table then try to maintian it the excel sheet with AOP value.

Then add this as dimension and in calculation for nov-10 you have to add an extra expression if(Expense ='Renta' then your current exp for rental.....

for the second method you need to check the performance.

Add column in report directly

suniljain — Tue, 04 Jan 2011 12:21:11 GMT

there should be link or you have to calculate expression in script by hard code