Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Contributor III

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

Hello,

Please see the below expression I have calculated:

=

num(

(sum(Rolling13Sum)*WEEK)

/sum(Rolling13Sum),'##.0')

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:

Count({\$<

num(

(sum(Rolling13Sum)*WEEK)

/sum(Rolling13Sum),'##.0')

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

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

Labels (3)

• ### Set Expression

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
Author

Hi,

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.

Thanks

Community Browser