Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jesstungleumi
Contributor III
Contributor III

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
jesstungleumi
Contributor III
Contributor III
Author

Anyone please?