Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Fields in combination

Hey

I have two fields ([Developer Name] and [Responsible Person]) in one table.  The two fields might be different and they could be the same.  Now, I need a list field, that I can use to show me where either of the two fields is = to the selected value in the list field.

For example.  If I select "Bradley Isaacs" in the list field, then the table box/chart should display rows where [Developer Name] = "Bradley Isaacs" or [Responsible Person] = "Bradley Isaacs".

Data:

LOAD 

     [In BAU date],

     [Responsible Person],

     [Developer Name],

     [% Complete],

     Description,

     Link,

     [Task Group],

     [Task Logged date],

     SubField([Responsible Person], '(', 1) as Responsibleperson_SubField

FROM

(ooxml, embedded labels, table is [owssvr (1)]);

Tags (3)
2 Replies

Re: Fields in combination

You can solve the problem in the front end side so:

1) Create a chart (straight table) with the following dimension

if(GetFieldSelections( [Responsible Person])= [Responsible Person] or GetFieldSelections([Developer Name])=[Developer Name], [Developer Name], Null())


then check the box suppress null value

2) add an expression: write 1 for example as expression

let me know

Not applicable

Re: Fields in combination

Thanks so much for your response Alessandro.  I've tried it, but it doesnt seem to be working.  Unless Im doing something wrong.

Wouldve attached the data file (xls), but not sure how to.