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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Help in expression

Hello
I have a pivot table with several expressions
I will show you 2 expressions 1 and 2 written in two different ways but they return the same correct result

expression 1 is not distributed on any dimension
while expression 2 is distributed on any dimension

ali_hijazi_0-1763064114002.png

but expression 2 is very slow when used with the remaining expressions in the pivot table
while expression 1 is much faster

Expression1:
{
$
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>
-<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>
}
sum(SPENT_MANDAYS)

Expression 2:

(
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 1 ID]={18}>}
sum(SPENT_MANDAYS)
-
{<[Parent PRoject Portfolio Level 1 ID]={1},[Portfolio Level 3 ID]={37}>}
sum(SPENT_MANDAYS)
)

 

kindly advise on why expression 1 is alwys under null scenario type

I can walk on water when it freezes
Labels (3)
10 Replies
ali_hijazi
Partner - Master II
Partner - Master II
Author

Well I've been working on Qlik since 2011 (QlikView)

Whenever I encounter such weird cases no one explains why whether on community or via support cases 

Ok I can add a composite field, but what if the script is not supposed to be changed meaning that I only can work on the UI which is the current situation? I assume that exclusion doesn't work well in Qlik

 

I can walk on water when it freezes