Create a list of calculated values

[edemerdjieva]

Hello,

I am trying to create a filter in a report whose values will be calculated against existing data in QlikView. Here is an example:

Goal: List in a table the emissions and uses of gift cards in a shop.

"Gift card status" filter values:

- active (issue date + validity <= today)

- expired (date of issue + validity> today) and balance<> 0

- all (targets both 'active' and 'expired' statuses)

In the QV model I have the following data:

- date of issue

- validity (number of days)

- initial amount

- balance

I thought about the ValueList function but I can not find a way to use it.

Every idea is welcomed .

Thank you in advance.

[sunny_talwar]

Why don't you do this in the script?

[uacg0009]

Hi Elina,

Please try this:

Dimension : =valuelist('active','expired')

Expression : if(valuelist('active','expired') = 'active',count(distinct if(issue date + validity <= today,gift card)),

                         count(distinct if(date of issue + validity> today and balance<> 0,gift card)))

And you can use show total function to see the all I think.

Thanks.

Aiolos