topic Re: Error in script in QlikView

Error in script

nikhilgarg — Tue, 31 Mar 2015 07:25:03 GMT

Hey, My script is:

=if(GetSelectedCount(_CalendatType) = 0 , $(vSalesbookUsage) ,

if(_CalendarType = 'Fiscal' , GetFieldSelections([TradeFiscalYear]) & '-' & GetFieldSelections([TradeFiscalQuarter]) ,

if(vTradeCalendarType = '1D' , date(max(){1}TradeDateMaster), 'MM/DD/YYY'),

if(vTradeCalendarType = 'Custom' , Date($(vTradeStartDate) , 'MM/DD/YYYY') & '-' & Date($(vTradeEndDate) , 'MM/DD/YYYY')))))

where, vSalesbookUsage = SalesBookUsage.

But issue is whenever i clear everything sometimes SalesbookUsage in straight table caption is not shown. Last Selected Date is shown. ALso when i reopen the file, last selected date is shown while it should show SalesBookUsage.

What to do??

Thanks

Re: Error in script

Tue, 31 Mar 2015 11:56:15 GMT

Hi,

Is the script copy-paste from your application? In the first line you have _CalendatType ...with a t.

// Fjalar

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 12:38:23 GMT

Well,

It is a typing mistake(Typo). Can you please tell what to do because whenever i reopen the document it shows last time selected date while i want if no date is selected or if we reopen document then SalesbookUsage should be written at caption of straight table.

Thanks

Re: Error in script

sunny_talwar — Tue, 31 Mar 2015 12:42:30 GMT

You can set a on open trigger within the document properties which essentially clears your selection for your date field.

HTH

Best,

Sunny

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 13:04:03 GMT

Thanks sunny,

it helped

Re: Error in script

sunny_talwar — Tue, 31 Mar 2015 13:05:06 GMT

Awesome, I am glad it was useful.

Best,

Sunny

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 13:34:10 GMT

Hey sunny,

Actually i am not allowed to del the trigger so is there any other way to acheive the same??

Re: Error in script

sunny_talwar — Tue, 31 Mar 2015 13:41:24 GMT

Hey Nikhil,

So you are trying to clear a field without using a trigger? Is that what your requirement is?

Best,

Sunny

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 13:58:09 GMT

Yes, actually i want when i open the doc in straight table's caption , Salesbook usage should be visible when no date is selected. But due to trigger by default calendar is selected.

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 17:12:57 GMT

Hey btw let say i have 2 tables with 2 common columns. I load one table

then voncatenate with other same columns table. Now i want to remove

duplicate columns also. What can we do for this?

Thanks

Re: Error in script

sunny_talwar — Tue, 31 Mar 2015 17:22:28 GMT

You can use where exist condition while concatenating to make sure you only load column entries which are not already present.

And answer to your first question: How to do it without trigger: I don't know any way (right now). I am going to do some research at my end to see if I can find a way to do it without using triggers.

Best,

Sunny

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 17:32:09 GMT

Thanx sunny. But shouldn't we use where not exist like;

1: load salespersonname from table1;

Concatenate

Load salespersonname from table2 where not exist salespersonname ;

Concatenate

Load salespersonname from table3 where not exist salespersonname ;

Is it so?

2: after loading above tables i want to use applymap() to get the

salesregion for all available salesperson. But i am in a fix how to get

that. Can you help.

Re: Error in script

sunny_talwar — Tue, 31 Mar 2015 17:48:07 GMT

Nikhil you are right. We will be using where not exist. I was just hinting towards the use of where exist condition, but the actual coding in your case would require you to use where not exist.

You need help with the syntax for ApplyMap?

Best,

Sunny

Re: Error in script

nikhilgarg — Tue, 31 Mar 2015 18:06:21 GMT

Actually i need to know how exactly i can apply the applymap() with above

code. I know the syntax although. I want to have salesregion for every

salesperson. Applymap() is used to get salesregion. Do i need to use

applymap() with evry load statement ?

Re: Error in script

nikhilgarg — Wed, 01 Apr 2015 07:48:07 GMT

Hey sunny,

I am using:

Table1:

Load SalespersonName,

applymap('Table2' , Desk , 'Unknown') as Desk,

applymap('Table3' , Region , 'Unknown') as Region ;

select salespersonname from table abc;

concatenate

Load SalespersonName ,

applymap('Table2' , Desk , 'Unknown') as Desk,

applymap('Table3' , Region , 'Unknown') as Region

where not exists(salespersonName);

select salespersonname from table def;

Is this correct?

Thanks