Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

showing field value

hi, i want to show a filed with string value, but with a condition. which function i can use?

7 Replies
MK_QSL
MVP
MVP

can you elaborate little more about your requirements?

Not applicable
Author

this  is my expression:

({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>})

i want to show value of X field when the condition is true

MK_QSL
MVP
MVP

Only({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>})

Not applicable
Author

but it shows nothing

anbu1984
Master III
Master III

Maxstring({<[d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}>})

Not applicable
Author

it shows nothing

Not applicable
Author

it shows nothing , maybe because i have no data related to this value (i had no X for [d Gregorian Full Date]={"$(=Date((today()-2),'YYYY-MM-DD'))"}). so it is showing nothing. how is it possible to show the X values which exist in Dimension table but i have no related data in my Fact tables?