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

Count on a Dimension in a Dimension table & Fact table

madnanansari — Tue, 15 Nov 2016 16:46:33 GMT

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.

Gysbert_Wassenaar — Tue, 15 Nov 2016 16:53:15 GMT

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

shraddha_g — Tue, 15 Nov 2016 16:56:05 GMT

What is d issue?

johnw — Tue, 15 Nov 2016 19:55:26 GMT

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)