How we can deal with such data in Set analysis?

[sspawar88]

Suppose i have Temperature database.

In set analysis

How we can count or sum for certain range like in between >=-1 to -10 ?

In set analysis How we can count or sum of the temperature which is only

above the 0 or

only minus value or

Will not count for 0 values or

for example in following set analysis

Count({$<param_name={'Temperature'},branch_type=>}param_value)

and

Sum({$<param_name={'Temperature'},branch_type=>}param_value)

Thanks in Advance

[MK_QSL]

Provide few lines of sample data...

You can use something like below...

Total Sales for Year 2010 to 2015

SUM({<Year = {">=2010<=2015"}>}Sales)

[#3]

Hi,

Try this:

Count({$<param_name={'Temperature'},branch_type=,param_value={'>=-10<=-1}>}param_value)

Assuming param_value field holds the temperature value.

[sspawar88]

param_value={'>=-10<=-1'}

or

param_value={">=-10<=-1"}

Which one i have to use ?

[MK_QSL]

I think Set Analysis will work in Qlik Sense also...

[sspawar88]

Year = {">=2010<=2015"}

or

Year = {'>=2010<=2015'}

Which one i have to use ?

[#7]

param_value={'>=-10<=-1'}

[jagan · Accepted solution]

Hi,

Try like this

Assuming Temperature is the field name

For Temperature >0 (Positive Values)

=Count({$<Temperature={'>0'},branch_type=>}Temperature)

For Temperature <0 (Negative values)

=Count({$<Temperature={'<0'},branch_type=>}Temperature)

For Temperature non 0 values (Other than 0)

=Count({$<Temperature-={'0'},branch_type=>}Temperature)

For -1 to -10

=Count({$<Temperature={'>=-1<=-10'},branch_type=>}Temperature)

Hope this helps you.

Regards,

Jagan.