Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modeling

Hi Community,

I am new to QV.

Hope anybody could help me please !!

I have a requirement to build the model and Dashboards

Requirements : in metrics/KPI's

1.Count of Unique Stores by User

2.Count of Unique Users

3.Total stores visited(actual)

4.Total stores should be visited

5.Pending Stores remained to visit

Below are the sample tables

    

Main Transaction table
IDUserDateProduct
abc111Lucy1/06/2015Pdc111
abc111Lucy1/06/2015Pdc112
abc112Lucy1/06/2015Pdc113
abc112Lucy1/06/2015Pdc114
abc113Lucy1/06/2015Pdc115
abd114Sean1/06/2015Pdc116
abd114Sean2/06/2015Pdc117
abd115Sean2/06/2015Pdc118
abd116White2/06/2015Pdc119
abc116White2/06/2015Pdc120
abc117White4/06/2015Pdc121
abc117White4/06/2015Pdc122

  

Detail(Unique)
IDStore
abc111Australia
abc112America
abd114Dubai
abc116-
abc117-
abc118Thailand

  

Lookup(Stores allocated to each user)
UserStores
LucyAustralia
LucyAmerica
LucyAustria
SeanDubai
SeanUK
SeanNizeria
WhiteSingapore
WhiteMalaysia
WhiteThailand

Thanks in Advance...

0 Replies