Set Analysis

sspawar88 — Wed, 24 Jun 2015 10:20:17 GMT

Hello Friends,

Here I'm trying to calculate the Percentage of Temperature in Drill down Approach.(Year-Month-Week-Day-Created_date)

i'm using the following Set analysis

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

Count(total{$<param_name={'Temperature'}>}param_value)*100

But it wont work as my expectation.

Which changes i have to make in it so that it can applicable for all Year-Month-Week-Day-Created_date?

Note : Created_date field consist thousands of records which generate after few minutes in a day

Formula Description-- Requirement is for Count of Tempe which is below -1 (i.e. -2,-3,-4...) upon Total Temperature (i.e. ...1,0,-1...all values) .

here i came across problem at created_date. it gives value like 0.001 on all data point.

is it correct?

if it is not correct what is the valid way to calculate it correctly for such temperature database.

please suggest from your experience !!

Re: Set Analysis

Anonymous — Wed, 24 Jun 2015 11:52:32 GMT

I think created_date is time stamp and you are simply converting it to Date()

Make sure you have correct time format and then use floor () to get the date

See example -

The Date Function

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

Count({1<param_name{'Temperature'}>}param_value)*100

Thanks

BKC

topic Re: Set Analysis in QlikView

Set Analysis

Re: Set Analysis