topic Re: show specific value in chart in QlikView

show specific value in chart

Anonymous — Wed, 06 Jan 2016 07:55:49 GMT

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

Re: show specific value in chart

sunny_talwar — Wed, 06 Jan 2016 11:01:44 GMT

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

Re: show specific value in chart

PrashantSangle — Wed, 06 Jan 2016 11:06:06 GMT

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

Re: show specific value in chart

sunny_talwar — Wed, 06 Jan 2016 11:11:03 GMT

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....)

Re: show specific value in chart

PrashantSangle — Wed, 06 Jan 2016 15:06:13 GMT

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,

Re: show specific value in chart

sunny_talwar — Wed, 06 Jan 2016 15:07:15 GMT