topic Re: Key and calculated field in QlikView

Key and calculated field

Mon, 02 Dec 2013 19:34:23 GMT

HI,

I need to make a comparison between the actual sales and the sales budget.

in the Budget tab I createda calculated field: Month(budgetMont) as Budget_Month it dosnt work from some rason.

And the second field I created is key field : BudgetYear&'-'&Budget_Month&'-'&CategoryID as KeyCompare .

The goal is to link the budget table and the sales table.-

In Sales tab I created: Year&'-'&Month&'-'&CategoryID as KeyCompare

I created twice, once in sales table and once in SalesHistoty table.

What is the problem? whay it dosnt work?

Also, how can I create a calculated field in sales tab?

Example: QTY * COST

Clever_Anjos — Mon, 02 Dec 2013 19:39:43 GMT

1) Month(budgetMont) as Budget_Month, Month function requires a date, you´re using a string "Jan", "Feb"

2) BudgetYear&'-'&Budget_Month&'-'&CategoryID I´d like to see you data Budget.xls

3) Year&'-'&Month&'-'&CategoryID as KeyCompare, I don´t see a field called Month and Year, maybe you´re talking about Month(Date), Year(Date)

Clever_Anjos — Mon, 02 Dec 2013 19:42:28 GMT

QTY * COST, you can calculate after the "left join"

Left join (Sales)

LOAD

ProductID,

Date,

QTY * COST as AFieldName

resident Sales

Mon, 02 Dec 2013 20:01:24 GMT

Thanks for your response.

Can you attach your answer with a QVD FILE?

Clever_Anjos — Mon, 02 Dec 2013 20:08:30 GMT

It would be easier if you send me sample of your data

Mon, 02 Dec 2013 20:17:56 GMT

You mean I'll send you the Excel files?

There is an option to send it in private message?

Clever_Anjos — Mon, 02 Dec 2013 20:19:55 GMT

Mon, 02 Dec 2013 21:04:58 GMT

I sent you an email