Discussion board where members can get started with Qlik Sense.
I have 2 tables that both contain Cust_no. One is a Sales table, another is a Usage table. Other fields in common are Period and Company_no
Cust_no as Sales_Cust_no Cust_no as Usage_Cust_No
Link Table contains Cust_no, Period, Company_no
In my charts - for Sales - I count Distinct Sales_Cust_no
for Usage I count Distinct Usage_Cust_no
1. Do I need to include Sales_Cust_no and Usage_Cust_no in my linking table?
2. I'd like to display how many Logons did a customer have that also had sales - would that be possible with the current design?
3. What would my expression look like for number 2 above?
4. any other ideas for other visualizations with the data as is?
Go to Solution.
Please refer below thread you will get idea:
Thanks & regards,
Thank you Arvind