Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help on conditional show of a pivot table column

Hi,

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

etc.

Thanks.

6 Replies
sundarakumar
Specialist II
Specialist II

In the expression where u r calculating the Delta add a condition like

if(monthfield<>month(today()),  ...expression...  , null())

-Sundar

Not applicable
Author

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?

sundarakumar
Specialist II
Specialist II

u want to supress the entire row or only the column which says delta for the latest month alone?

PrashantSangle

Hi,

Try like this in delta expression,

If(num(month(datefield(YYYYMM)))<>num(month(today())),delta Expression)

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sundarakumar
Specialist II
Specialist II

pls share the expression that u have used and sa sample data of how it is in the back end?

sundarakumar
Specialist II
Specialist II

I guess this expresison would suppress all '"September" data all together.