Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Count "values" of set expression, in range of two values


Please see the below expression I have calculated:






From this expression, I am trying to create a chart that shows how many values are associated to a categorized range of numbers. The dimension it should be calculated against is PRODUCT.

So, for example

1-6WKS = 876

6-7WKS = 987

8-15WKS = 621


I'm figuring that I would need to use the Count function, but am having difficulty in doing so. 

This is what I am trying:





= {'>1<6'}>} PRODUCT)


This however, will not portray any data. Can I not use a set expression after Count?

Thanks in advance!

Labels (3)
2 Replies

Perhaps this?

Count({<PRODUCT={">1<6"}>} Aggr(num((sum(Rolling13Sum)*WEEK)/sum(Rolling13Sum)),'##.0'), Product))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Contributor III
Contributor III


Thanks for the response. Unfortunately, it keeps saying there is an "Error in Expression". 

It is highlighting the end: , Product))

I think it is a simple syntax error, but I'm having trouble getting it to read it.