topic How to code that the USER SELECTED number of rows in a pivot table should be calculated? in App Development

How to code that the USER SELECTED number of rows in a pivot table should be calculated?

materi — Tue, 25 Jun 2019 09:09:47 GMT

I posted a question previously with the same code, so here it is again:

307.699 * count(Period)

What I want that expression to do is what I describe in the topic, but what it does is simply count the total number of rows in the field Period and returns the product of that and the given number.

How do I make Qlik only return the user selected number of rows in the field Period instead?

Re: How to code that the USER SELECTED number of rows in a pivot table should be calculated?

materi — Tue, 25 Jun 2019 09:20:36 GMT

The field Period contains dates of weeks as such: 201540, 201541, 201542 and so on. But I don't think that should matter, because of the count argument, which should only make it count rows in the field, as specified by the user. Why doesn't it do that?

For example, I selected one week (201540) and the result was 251764.4 which is not equal to 307.699 * 1.

Re: How to code that the USER SELECTED number of rows in a pivot table should be calculated?

materi — Tue, 25 Jun 2019 09:39:45 GMT

Aha, it turns out I had more than one of the same post in my dataset, so I used count(distinct[attribute]). That solved it. Thanks me!