Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

use alternate state in label

Can any one tell me how I would edit this label expression so that it uses the date selections from an alternate state

 

The alternate state is called TEST

 

='Sales £ all ' & min(date((PostingDate),'DD/MM/YY'))&'-'&Max(date(PostingDate,'DD/MM/YY'))

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))

View solution in original post

1 Reply
Highlighted
MVP
MVP

Try like:
='Sales £ all ' & min({TEST}date((PostingDate),'DD/MM/YY'))&'-'&Max({TEST}date(PostingDate,'DD/MM/YY'))

View solution in original post