Discussion Board for collaboration regarding Qlik DataMarket.
I want to count how many Products from a specific Producer do i have in a given Restaurant.
Anybody can tell me how to solve this ?
May be create a straight table with Dimensions -> PRODUCER and RESTAURANTS and Expression -> Count(DISTINCT Products) or Count(Products)?
I have a Map with GeoPoints corresponding each one to a Restaurant. Each restaurant can have products from two different producers.
I need something that works like this: SELECT Product FROM RESTAURANTS_PRODUCTS WHERE Name = "restaurantX" AND Producer="producerX"
This query would retrieve the products from restaurantX produced by producerX. I just need the number of rows retrieved in order to customize the restaurant marker on the map.