Discussion Board for collaboration related to QlikView App Development.
I have a pivot table with an ID and a date field (YYYYMM) as dimensions.
One of the expressions is a delta calculation between revenue and revenue one month before. How can I hide that delta column for the latest month?
So I would have
201408 (latest month) with revenue column
201407 with revenue and delta column
201406 with revenue and delta column
In the expression where u r calculating the Delta add a condition like
if(monthfield<>month(today()), ...expression... , null())
Unfortunately, this has no effect in my application.
By the way, my assumption was that I have to work with a Conditional expression and not with the Expression itself to suppress the whole column. Am I wrong?
u want to supress the entire row or only the column which says delta for the latest month alone?
Try like this in delta expression,
pls share the expression that u have used and sa sample data of how it is in the back end?
I guess this expresison would suppress all '"September" data all together.