Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Only show part of the result

Hi guys,

I've got 2 tables. Table1 is a pivot table, it shows customer A and visit_date 01/01/2018, table2 is a simple table, and has all the year-to-date visit_details for customer A. If I click customer A in table1, table2 will give me all the year-to-date visit_details. Is it possible it only gives me visit_details on 01/01/2018?

Thanks for help!

9 Replies
zebhashmi
Valued Contributor

Re: Only show part of the result

if a link in between the tables would be Date it should show only 01/01/2018

or you can use set analysis

regards

wanyunyang
Contributor

Re: Only show part of the result

The link is customer. How to use set analysis in this case?

Thanks!

zebhashmi
Valued Contributor

Re: Only show part of the result

Only({<customer A = P(Date)>}Date)

wanyunyang
Contributor

Re: Only show part of the result

Could you please explain a little bit what is {<customer A = P(Date)>}?

I'm trying to write something like {<date_in_table1=date_in_table2>}.

zebhashmi
Valued Contributor

Re: Only show part of the result

is it worked for you?

you are asking about p()

you can use (if )you have two different names of your fields

max(aggr(if(date_in_table1=date_in_table2,date_in_table2,'')))

or

p(date_in_table2={'date_in_table1'} in first one


zebhashmi
Valued Contributor

Re: Only show part of the result

{<date_in_table1={'date_in_table2'}>}

should work

wanyunyang
Contributor

Re: Only show part of the result

I have the same name of my fields. Do you mean customer A is the column I should use?

Now my function is like Only({<[Customer]= P(Date)>}Date). It doesn't work.

zebhashmi
Valued Contributor

Re: Only show part of the result

try that

Only({<date_in_table1={"=date_in_table2"}>}date_in_table2)

wanyunyang
Contributor

Re: Only show part of the result

they both named 'Date' in table1 and table2