Select based on expression

Anonymous — Sat, 07 Jan 2012 17:42:20 GMT

Is it possible dispaly in a chart only those records where the output of an expression in that chart meets a criteria? Say the expression output is 1 or 0, and I only want to view those records where it is 1. I know I should probably put a flag in the script and use that as a dimension, but I cannot do that at this time.

Re: Select based on expression

Miguel_Angel_Baeyens — Sat, 07 Jan 2012 20:05:12 GMT

Hi,

You will need to use the original expression in a conditional then. Say Count(FileNo) is your original expression that returns 1 or 0, and that the expression that you want to use is Sum(ByteSize) if that expression equals to 1:

If(Count(FileNo) = 1, Sum(ByteSize))

The If() will slow your chart considerably though, so think on that flag field or something to improve performance if you have some thousands of rows.

Hope that helps.

Miguel

topic Re: Select based on expression in QlikView

Select based on expression

Re: Select based on expression