topic Re: Create a list of calculated values in QlikView

Create a list of calculated values

edemerdjieva — Thu, 18 Jan 2018 08:46:35 GMT

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 — Thu, 18 Jan 2018 17:40:06 GMT

Why don't you do this in the script?

uacg0009 — Fri, 19 Jan 2018 04:13:09 GMT

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