Graph

[#1]

Hi Qlikview Community,

As you can see on the picture It was sorted in Descending order, is it possible not to include on the graph those who has Penalty?

can you give me some tips an tricks on Qlikview?
Thanks in Advance QC

[Chanty4u]

hi

you can diable that dimension .that wil not appear.

and u can arrange dem in sort tab either ascending or descending.

or else u can use Getfield selection('Field',0)

hope this helps u

Thank u

Suresh

[#3]

Hi suri qv,

can you teach me how does Getfield selection('Field',0) work? where do i put that syntax ni Qlikview?

and I think disabling the means I need to unchecked the Enable checkbox  in Expression? is that what are you telling me to do sir?

Thanks for comment by the way sir

[aveeeeeee7en · Accepted solution]

Hi

Try this Expression:

Sum({<penalty={"<=0"}>}[curr-assess])

The Result:

Also, see the Attachment.

Regards

Av7eN

[#5]

Hi sir Av7eN,

Where am I going to put the expression you give to me? Is it in [curr-assess] or in penalty? It seems you got the it right sir.

Thanks sir

[aveeeeeee7en]

You share me your expressions

[aveeeeeee7en]

No need of showing Penalty Expression if you don't want to show Penalty Amount.

Because The Bar is not generated for Zero Amount.

Show only 1 Expression for [curr-assess]: Sum({<penalty={"<=0"}>}[curr-assess])

It will exclude the Penalty Amount.

Regards

Av7eN

[#8]

the expression that i use is [curr-assess] and penalty only.

where i will put this 'Sum({<penalty={"<=0"}>}[curr-assess])' sir?

[#9]

Got it sir, Thanks