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: 
suvechha_b
Creator III
Creator III

How to write the expression

Hi ,

How to ommit the null division code :

See attachment:

For eg,

The NULL Division Code is summing up the "Budget Units" for other division code

Capture.PNG

I dont want the sum up of "Budget Units" in NULL Division Code.

Output should be "Budget Units":

CI10 9878

U001 12

How to write the expression for Inbound Orders , Blocked Stock and Actual receipts as they are not having division code.

See attachment.

Capture2.PNG

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I dont want the sum up of "Budget Units" in NULL Division Code.

SUM({<[Type Indicator] = {'B'}, [Division Code]={'*'} >} Quantity)


Same for the other expressions.


talk is cheap, supply exceeds demand
rubenmarin

Hi, checking 'Supress null values' in [Division Code] dimension can be an option?

marcus_sommer

Beside your question - you have a lot of sythetic keys within your datamodel which could cause problems. Recomended is to resolve these sythetic keys, see for this: Synthetic Keys.

- Marcus