Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

calculated dimension from another chart

Hello

I got a pivot table with 2 dimensions(ItemID, Date) and 2 expressions (E1, and E2)

this pivot table shows a sample data the following

ItemID     Date           E1          E2

27          28/8/2007     4500      5

27          29/8/2007     -            -

34          28/8/2007     3450     5

34          29/8/2008     -           -

...

now what I want is a clone of this above pivot table but only showing the rows with non null expression values

knowing that the expression E1 is very complex and I forced it to show NULL() if a certain condition was satisfied

I can walk on water when it freezes
0 Replies