How to create a graphic with calculated dimensions

josem_lopezp — Wed, 25 Nov 2020 16:16:04 GMT

Hi everybody,

I'm trying to create a graphic with a calculated dimension. The objective of this dimension is to make a filter inside a field and then operate the resulting value inside a expression.

For example, i have a table that contains 4 possible status of an item (01, 02, 03, 04) but i only want to work with the items which status is for example: 01 and 02. Which is the correct syntax to archive this goal?

Thank you in advance

Re: How to create a graphic with calculated dimensions

pradosh_thakur — Tue, 05 Feb 2019 17:49:23 GMT

In the script

Where match(status,01,02)

in epression
if(status=01 or status =02, dimension,null()) and then supress null

or

use set analysis with {<status={01,02}>}

topic How to create a graphic with calculated dimensions in QlikView

How to create a graphic with calculated dimensions

Re: How to create a graphic with calculated dimensions