Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
qlikviewsam
Contributor

Drop fields on run time

Hi All,

Please let me know how to implement drop field dynamically

Example :

Table 1:

Region Customer

A     ABC

B     BDE

Table2:

Region Customer

*           ABC

B          *

Drop field based on the Table 2 entry,

example:

first time it has to drop region field from Table 1 , bcoz * is entered in Table 2 Region Field

Second time it has to drop Customer field from Table 1 , bcoz * is entered in Table 2 Customer Field

Thanks in advance

Tags (1)
3 Replies
Highlighted

Re: Drop fields on run time

May be this?

Table1:

Load * Inline [

Region, Customer

A,     ABC

B,     BDE

];

Qualify *;

Table2:

Load * Inline [

Region ,Customer

*           ,ABC

B          ,*

];

Final:

NoConcatenate

If Table2.Region = '*' or Table2.Customer = '*' Then

Drop Field Table2.Region;

Else

Drop Field Table2.Customer;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
big_dreams
Contributor III

Re: Drop fields on run time

Can you explain real scenario??

Difficult to understand.

Regards,

Highlighted
el_aprendiz111
Valued Contributor

Re: Drop fields on run time

Hi,

Table1:
Load * Inline [
Region, Customer
A,     ABC
B,     BDE
]


;

Outer Join

Table2:
Load * Inline [
Region ,Customer
*,ABC
B,*
]

;



Mapping  Reg: LOAD Region,Customer Resident Table1    ;
Mapping  Cus: LOAD Customer,Region Resident Table1    ;



SUMARY:
LOAD *, ApplyMap('Cus',Customer,Null()) AS Region1,
ApplyMap('Reg',RegionNull())  AS Customer1
 
 
Resident Table1
  ;

DROP Table Table1;



mapp2.png