topic Re: How can i add brand in script in QlikView

How can i add brand in script

Tue, 13 Nov 2012 15:05:02 GMT

Hi,

I have 12 brands, dimension name in BrandName.I want to add 'total' name in my brands that is 13th brand as total.

How can i add this brand in edit script.Can anyone have idea about this....

regards,

baru

Re: How can i add brand in script

jvitantonio — Tue, 13 Nov 2012 15:08:22 GMT

Hi, I don't know if I understood correctly but if you want to add one more row with the description "Total" then you can concatenate your tables like:

Brand:

LOAD BrandName FROM... ;

Concatenate

LOAD * INLINE [

BrandName

Total

];

If what you want to sum up the brand then this is done in your fact table and not in your dimension table.

Re: How can i add brand in script

its_anandrjs — Tue, 13 Nov 2012 15:24:46 GMT

Hi,

Yes you can add another 13 value from any inline table

Brand:

LOAD

[

BrandName

] from source;

Concatenate

LOAD * INLINE

[

BrandName

Total

];

but related to this values in another table shows null so you have to work on them

Regards,

Anand

Re: How can i add brand in script

Anonymous — Tue, 13 Nov 2012 15:24:47 GMT

Why you want a 'Total' in the brands list? Maybe there are different ways of achieving what you are trying to accomblish! I mean more efficient way .

Regards

MultiView

Re: How can i add brand in script

Tue, 13 Nov 2012 15:38:49 GMT

Hi,

thanks for your reply,

Actually i want to show in my report 12 brands and total column that is in my pivot table.i am having only one expression in my table.

When i drag brand dimension in vertical position,the 12 brands having one expresion and for total i am having one expresion.

I thought that i will give expression for the brandname and in the same expression i will give another expression based on the if condition.

so i need to add one text as total in brandnames.

regards,

baru

Re: How can i add brand in script

Anonymous — Tue, 13 Nov 2012 16:05:51 GMT

Follow these steps.

1 - On your pivot table --> Properties --> Presentation --> Click on the Brands dimension --> Label for Totals --> Input "Total".

2 - On the same Presentation window select 'Brands dimension' and there is a subsection called Subtotals, you can select Subtotals on top or bottom as per your requirement.

I hope this helps!

MultiView

Re: How can i add brand in script

Tue, 13 Nov 2012 16:25:17 GMT

Hi,

here i want to give the expression for the total thats not related to sum(columns) totals.

regards,

baru