topic How we can deal with such data in Set analysis? in QlikView

How we can deal with such data in Set analysis?

sspawar88 — Thu, 18 Jun 2015 05:55:47 GMT

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

Re: How we can deal with such data in Set analysis?

MK_QSL — Thu, 18 Jun 2015 06:10:07 GMT

Provide few lines of sample data...

You can use something like below...

Total Sales for Year 2010 to 2015

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

Re: How we can deal with such data in Set analysis?

Thu, 18 Jun 2015 06:15:30 GMT

Hi,

Try this:

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

Assuming param_value field holds the temperature value.

Re: How we can deal with such data in Set analysis?

sspawar88 — Thu, 18 Jun 2015 06:28:21 GMT

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

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

Which one i have to use ?

Re: How we can deal with such data in Set analysis?

MK_QSL — Thu, 18 Jun 2015 06:29:31 GMT

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

Re: How we can deal with such data in Set analysis?

sspawar88 — Thu, 18 Jun 2015 06:31:44 GMT

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

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

Which one i have to use ?

Re: How we can deal with such data in Set analysis?

Thu, 18 Jun 2015 06:33:13 GMT

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

Re: How we can deal with such data in Set analysis?

jagan — Thu, 18 Jun 2015 06:43:21 GMT

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.