topic Re: Using an Expression as a Set Analysis Value in QlikView

Using an Expression as a Set Analysis Value

Sat, 21 Jun 2014 22:13:10 GMT

I am displaying a line graph of multiple application names and their corresponding "uptime" percentage per month / year.

The dimensions are Year, month in a drill down group and app name.

Year, month on the X axis and App name on Y axis.

I need for the graph to show only uptime based on the year 2013 and not the current selections.

Below is what I have and I would appreciate any help getting this to work.

= sum({<Year = {2013}>}(([Minutes MTD] - sum([Total_Impact_Minutes])) / ([Minutes MTD])))

Re: Using an Expression as a Set Analysis Value

phaneendra_kunc — Sun, 22 Jun 2014 04:38:19 GMT

Can you provide a sample data?

Re: Using an Expression as a Set Analysis Value

sundarakumar — Sun, 22 Jun 2014 04:39:59 GMT

Hi,

pls specify the formula that u want to implement the set analysis.

u don't need to implement the set analysis in only one aggregate function as u have done now.

what u have done now is

(a {set analysis} -b/c).

I would prefer to use it as

((a{Set analysis})-(b{set analysis}))/(c{set analysis})

sum({<year={$(=max(year))}>}sales) this would return the max year among the selection.

where sum({1<year={$(=max(year))}>}sales) this would return the max year irrespective of selections.

hope this helps.

-Sundar

Re: Using an Expression as a Set Analysis Value

robert99 — Sun, 22 Jun 2014 10:47:52 GMT

//first formula

= sum({<Year = {2013}>}(([Minutes MTD]

// is this the second formula?

- sum([Total_Impact_Minutes])) / ([Minutes MTD])))

Are you getting an error at present?

Re: Using an Expression as a Set Analysis Value

Sun, 22 Jun 2014 17:27:08 GMT

Here is the graph that I want to display that is independent to the current selections. The expression that I am using shows the uptime for the application. The current expression is "=(([Minutes MTD] - sum([Total_Impact_Minutes])) / ([Minutes MTD]))"

[Minutes MTD] is the number of minutes per month

sum[Total_Impact_Minutes] is the sum of the impact minutes for the application

As an example for "Internet Availability in July 2013" there was a total of an 2 minute outage. In order to achieve the uptime % for Internet Availability in July 2013 I have to calculate the following.

=(([Minutes MTD] - sum([Total_Impact_Minutes])) / ([Minutes MTD]))"

=(([44640] - sum([2])) / ([44640])) = roughly 0.999955

Is set analysis the best way to achieve this to show only the year 2013 and not based on current selections?

Re: Re: Using an Expression as a Set Analysis Value

Sun, 22 Jun 2014 17:32:20 GMT

The tab that contains what I need help on is called "uptime 2013"

Re: Using an Expression as a Set Analysis Value

Sun, 22 Jun 2014 17:36:40 GMT

I have attached sample .qvw below along with a detailed description.

Re: Using an Expression as a Set Analysis Value

Sun, 22 Jun 2014 17:38:23 GMT

RJ,

Thank you for the help! The suggestion did not work. I have attached sample .qvw below.

Re: Using an Expression as a Set Analysis Value

robert99 — Mon, 23 Jun 2014 06:04:36 GMT

It was a question

I'm unsure what you are trying to do