Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
if a link in between the tables would be Date it should show only 01/01/2018
or you can use set analysis
regards
The link is customer. How to use set analysis in this case?
Thanks!
Only({<customer A = P(Date)>}Date)
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>}.
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
{<date_in_table1={'date_in_table2'}>}
should work
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.
try that
Only({<date_in_table1={"=date_in_table2"}>}date_in_table2)
they both named 'Date' in table1 and table2