Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

show specific value in chart

Hello guys

i try to show specific values of field "EXPR3" on chart but it doesn't work

i write" if(Expr3='502156' or Expr3='502155' or Expr3='502135' or Expr3='502170',Expr3)" in definition in expressions tab and "fullname" as a dimention

but it just act when i select these values

i want show them without selection

1 Solution

Accepted Solutions
PrashantSangle

Hi,

try like

in Expression

Only({<Expr3={'502156','502155','502135','502170'}>}Expr3)

Edit :

Or you can create new field in script and use that field in expression

try like

if(Match(Expr3,'502156','502155','502135','502170'),Expr3) as modified_Expr3

and use modified_expr3 in your 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 🙂

View solution in original post

5 Replies
sunny_talwar

What exactly is your expression?? Expr3 outputs a number like this?

PrashantSangle

Hi,

try like

in Expression

Only({<Expr3={'502156','502155','502135','502170'}>}Expr3)

Edit :

Or you can create new field in script and use that field in expression

try like

if(Match(Expr3,'502156','502155','502135','502170'),Expr3) as modified_Expr3

and use modified_expr3 in your 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 🙂
sunny_talwar

max I have a feeling that Expr3 is not a field but an expression and that is why I was hesitant to provide a solution before looking at the expression itself. But if it just a field then what you have proposed 1st should work. I am still not sure if the second one will work if it did not work with if(... or....)

PrashantSangle

Hi,

Yes Sunny without data we can not give any proper solution.

It was just guess.

Dear it-golestan,

If solution don't work, Please provide sample data with expected output.

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 🙂
sunny_talwar