topic How to change Labels? in QlikView

How to change Labels?

Fri, 25 Mar 2011 03:46:09 GMT

Hey friends, i have a problem.

I have a CHART, with one dimension called COMPANY.

under COMPANY, i have the names of different companies, such as SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

how do i change the COMPANY label, such that, when i open the CHART, it only has APPLE and DELL under the COMPANY dimension.

So basically,

1) 1 CHART with a COMPANY dimension.

2) COMPANY : SONY, APPLE, DELL, HTC, NOKIA, SAMSUNG & PANASONIC.

3)modify COMPANY dimension such that, COMPANY only has APPLE and DELL.

can this be done ? THANKS! 😄

How to change Labels?

deepakk — Fri, 25 Mar 2011 03:58:03 GMT

hi Nilesh,

You can try out the below code in scriipt.

if(COmpany ='Dell' or Company ='Apple' ,Company) as Company2.

And use this Company2 in your dimension.

How to change Labels?

Fri, 25 Mar 2011 04:23:58 GMT

Thank you Deepak.

By the way, i am student training under Mr. Paul Yeo. Could i ask you for a sample programme from visual basic for a quotation purpose ?

1) User will access Qlikview for Manu.No ,part.no, Cost, FOB, CIF.

2) Data will import to VB programme under the quotation softare.

3) User is able to access the customer database for company address, company name, contact.person etc.

This will help me in my Final Year Project. Please let me now how much we need to compensate you for this service, Thank you!

How to change Labels?

Fri, 25 Mar 2011 04:35:48 GMT

By the way,

if(COmpany ='Dell' or Company ='Apple' ,Company) as Company2,

if i'm right, the correct one should be, if(COMPANY = 'DELL' or COMPANY ='APPLE',COMPANY) as Company2,

But i cannot get the result i wanted. The script cannot be loaded.

Is there maybe another way ?

How to change Labels?

deepakk — Fri, 25 Mar 2011 04:56:33 GMT

hi Nilesh,

Can up attach a sample file.

I will try to send you u sampe QUo application by weekend.

How to change Labels?

Mon, 28 Mar 2011 01:04:29 GMT

Hello! Are you done with the sample application ? Could you send it over ?

Thanks!!

How to change Labels?

Mon, 28 Mar 2011 01:54:13 GMT

Hi for the previous question also! for the expression

if(company ... )

is there any other method ?

How to change Labels?

Mon, 28 Mar 2011 07:25:26 GMT

Hey deepak!

the thing i want to change is the label! not change the script..

is there anyway to add it in the label ?