Discussion board where members can get started with Qlik Sense.
Have a scenario such that, I want calculate the count(user) with restrictions such that, if the user comes to same place twice in a day the count of visit is 1, also if the user visit in two different cities in same day, the visit count is 1.
Maybe use an expression something like
If ( Count(UserID) > 1 , 1 , 0 )
This is not working.
try like this
if(CityID = CityID and ComeDate = ComeDate,1,
if(CityID <> CityID and ComeDate = ComeDate,1,0)) as CountVisits
(ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is Sheet2);
count( distinct UserID+ComeDate )