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: 
Anonymous
Not applicable

QlikSense dynamic expression label

Hi, I want to display different labels for the same expression under the same dimension.

For example:

Dimension - Product Type - value: Loans, Revenue

Expression - If [Product Type]='Loans', sales of this month,

                     If [Product Type]='Revenue', sales of YTD

                     sum(sales of Loans of this month) + sum(sales of Revenue of YTD)

I want to display Nov '17 for Loans, and Nov '17 YTD for Revenue, how do I do that?

I tried if, aggr, set analysis with P, but none of them worked because they don't recognize the dimension.

Dynamic label works at app level.

Dynamic Label.pngDynamic Label2.PNG

1 Reply
Anonymous
Not applicable
Author

Anyone please?