topic Re: Calculation based on dimension in QlikView

Calculation based on dimension

Neo — Sun, 31 May 2020 08:55:56 GMT

Hi there,

I have multiple group segment each with designated stores. I want to calculate the percentage of store with sales for each group segment

e.g.

Corporate Segment has 10 store in total, 7 stores made sales in April so 70% strike rate

Now I want to present this in a chat showing only Group Segment and Strike rate for the month (Calculation is based on stores but I don’t want to show store in the table/dimension)

i.e.

Group Segment	Store	Strike	Strike Rate
Corporate	26	22	85%
Corporate Budget	27	23	85%
Hyper	20	18	90%
Mini Market	13	7	54%
Family	21	19	90%
Family Budget	22	21	95%

Re: Calculation based on dimension

rwunderlich — Sun, 31 May 2020 17:19:34 GMT

You didn't show your raw data so I'll guess that having sales means the field Sales>0

Dimension:
Group Segment

Measures:
1. Count(Distinct StoreId)
2. Count({<Sales={">0"}>}Distinct StoreId)
3. Column(2) / Column(1)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Calculation based on dimension

Neo — Mon, 01 Jun 2020 16:23:19 GMT

thank you Rob works perfectly

How would I only count storeID where sales 2019 > sales 2018