Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
josem_lopezp
Contributor
Contributor

How to create a graphic with calculated dimensions

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

1 Reply
pradosh_thakur
Master II
Master II

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}>}
Learning never stops.