Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

madnanansari
New Contributor III

Count on a Dimension in a Dimension table & Fact table

I have these three tables in my app:

ITEMS

SALES

INVENTORY

I have to report the below:

- How many Items are defined in the Item master file.  (Count of items in item master file)

-How many items are available in stock (count of items in stock file)

-How many items have sales transactions (count of items in sales file).

pls. let me know how to do this analysis.

3 Replies

Re: Count on a Dimension in a Dimension table & Fact table

I assume you've found out you need the count() function. But what are you having problems with exactly?


talk is cheap, supply exceeds demand
shraddha_g
Honored Contributor III

Re: Count on a Dimension in a Dimension table & Fact table

What is d issue?

MVP
MVP

Re: Count on a Dimension in a Dimension table & Fact table

I assume all items are in the master file. I don't know your field names, but something along these lines perhaps.

count(distinct Item)
count({<StockAmount={">0"}>} distinct Item)
count({<SaleAmount={">0"}>} distinct Item)

Community Browser