topic Re: Graph in QlikView

Graph

Fri, 19 Jun 2015 02:07:21 GMT

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

Re: Graph

Chanty4u — Fri, 19 Jun 2015 02:41:47 GMT

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

Re: Graph

Fri, 19 Jun 2015 02:48:41 GMT

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

Re: Graph

aveeeeeee7en — Fri, 19 Jun 2015 03:14:03 GMT

Try this Expression:

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

The Result:

Also, see the Attachment.

Regards

Av7eN

Re: Graph

Fri, 19 Jun 2015 03:22:59 GMT

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

Re: Graph

aveeeeeee7en — Fri, 19 Jun 2015 03:24:57 GMT

You share me your expressions

Re: Graph

aveeeeeee7en — Fri, 19 Jun 2015 03:27:58 GMT

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

Re: Graph

Fri, 19 Jun 2015 03:32:46 GMT

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

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

Re: Graph

Fri, 19 Jun 2015 03:45:29 GMT

Got it sir, Thanks