topic Filter Chart based on condition in QlikView

Filter Chart based on condition

ivandrago — Thu, 10 Feb 2011 14:33:46 GMT

Hi,

I have the attached document, there is a graph on there that I only want to show the names where they have a total amount over $400

Thanks

Filter Chart based on condition

Anonymous — Thu, 10 Feb 2011 14:46:52 GMT

Hi Ivan,

I have edit your Dimension.

Check teh file please.

Good Luck.

Filter Chart based on condition

ivandrago — Thu, 10 Feb 2011 16:11:08 GMT

Thanks Dennis!

How hard is it to amend this so that it includes a Input box so the user can enter the amount they want to show, so the Graph will look at the amount the user has entered?

Filter Chart based on condition

Anonymous — Thu, 10 Feb 2011 17:19:05 GMT

I added a variabel (vAmount) which you can fill or use the slide I add.
Let me know if this is what you need.

Filter Chart based on condition

Anonymous — Thu, 10 Feb 2011 17:27:42 GMT

btw I would suggest that you SUM your amounts (grouped by person) in your script (as Amount_Total)

and then use that in your dimension:


=If(Amount_Total>vAmount,Name)

Filter Chart based on condition

ivandrago — Thu, 10 Feb 2011 17:28:19 GMT

Thanks for the quick response! I

have tried the attached when I typed in 682 I expected to see the following names to show:

Bob (896)

Bill (1000)

Chris (2096.59)

This is because they are over 682, with Jack and John not showing because there Total Amount was under 682.

Thanks

Filter Chart based on condition

Anonymous — Thu, 10 Feb 2011 18:35:06 GMT

Yes, see my previous comment.

You should SUM the amounts because now it leaves out ALL amounts lower then the variable.

Filter Chart based on condition

ivandrago — Thu, 10 Feb 2011 20:32:00 GMT

Sorry Dennis, did not see that part of comment; so is that the only way I can aggregated this field is doing via the script?

Filter Chart based on condition

ivandrago — Thu, 10 Feb 2011 21:16:20 GMT

Dennis, I have amended thescript so I have added another Field called "TotalAmmount", do you know why the graph is showing a bar that should not be there and also why does it not have a Name for this?

Filter Chart based on condition

Anonymous — Thu, 10 Feb 2011 21:59:41 GMT

Hi Ivan,

Just check "Suppress When Value is Null" at the Dimension.

That will do the trick I think.