topic Re: create new dimension category in QlikView

create new dimension category

Anonymous — Fri, 25 Jul 2014 17:07:31 GMT

Hi,

I have 14 categories from Database column(dimension) and showing values for the expressions in a stright table . Now, I want to include one more category which is category14-category13- category12 which is not present in datasource showing all values of expression. How can I include this?

Re: create new dimension category

Fri, 25 Jul 2014 17:29:51 GMT

In the script:

[TableName]:

LOAD

Category1,

Category2,

Category3,

Category1 & Category1 & Category1 as [Name]

;

sql

select * from table;

Re: create new dimension category

aveeeeeee7en — Fri, 25 Jul 2014 17:50:14 GMT

Hi Praveena

I think you're talking about Composite Key. You have to create this key in your Backend Script.

Your_Table_Name:

Load

category1,

category2,

category3,

category4,

category5,

category6,

category7,

category8,

category9,

category10,

category11,

category12,

category13,

category14,

category14&'/'&category13&'/'&category12 // Composite Key formation

From ......./Tablename.qvd(qvd);

After adding category14&'/'&category13&'/'&category12 in your Backend Script, Reload the Application and see this Key Result.

Regards

Aviral Nag

Re: create new dimension category

Anonymous — Fri, 25 Jul 2014 17:57:36 GMT

sorry, I think I did not explain well,Composite key is not my desired result, I want sum(category14, -category13, -Category12) for all expressions

Re: create new dimension category

Fri, 25 Jul 2014 17:59:10 GMT

[TableName]:

LOAD

Category1,

Category2,

Category3,

(Category14 + Category13 + Category12 )as [Name]

;

sql

select * from table;

Re: create new dimension category

aveeeeeee7en — Fri, 25 Jul 2014 18:10:55 GMT

Could you please Attach your sample Application.

Re: create new dimension category

crusader_ — Fri, 25 Jul 2014 19:27:25 GMT

Hi,

In this case better to use Rangesum() function to avoid possible mistakes.

[tblNm]:

LOAD

Cat1,

Cat2,

...

Rangesum(Cat12,Cat13,Cat14) as SumCat

;

sql ...;

Andrei

Re: create new dimension category

Mon, 28 Jul 2014 13:52:46 GMT

sent me your document, i help with that

my email is fredy7@gmail.com