Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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! 😄
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.
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!
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 ?
hi Nilesh,
Can up attach a sample file.
I will try to send you u sampe QUo application by weekend.
Hello! Are you done with the sample application ? Could you send it over ?
Thanks!!
Hi for the previous question also! for the expression
if(company ... )
is there any other method ?
Hey deepak!
the thing i want to change is the label! not change the script..
is there anyway to add it in the label ?