topic Re: Using set expression in a graph dimension in QlikView

Using set expression in a graph dimension

Mon, 25 Jun 2012 16:24:01 GMT

Hi everybody,

I have a graph with time as dimension and the following formula as expression:

count(DISTINCT

Project=

,[Project Type]=

,[Project Category]={"Execution"}

,SA_PER_ORG_P={"EMP"}

[Project Category] = {"Potential"}

,SA_PER_ORG_P={"EMP"}

}

EMPLID_RD)

The formula counts the distinct Employee ID considering the intersection of the two set defined in the set expression (red and blue).

I need to display a table (pivot table, linear table) with the list of the distinct emplid counted in the formula for a single month, with their properties.

Due to set expression in the formula, the list of possible EMPLID (white EMPLID) is different from the list i would like to obtain.

Do you have any suggestion to obtain my target list?

I tried to use set expression as dimension of a graph but it didn't work.

I thougth to use alternate state, but i can simulate only one of two state defined in the set expression.

Thanks in advance,

Giampaolo

Re: Using set expression in a graph dimension

v_iyyappan — Mon, 25 Jun 2012 17:00:15 GMT

Hi,

Use this expression like this

count( {$ < Project=,

[Project Type]=,

[Project Category]={"Execution","Potential"} ,

SA_PER_ORG_P={"EMP"} > }

DISTINCT EMPLID_RD)

Regards,

Iyyappan

Re: Using set expression in a graph dimension

Mon, 25 Jun 2012 17:08:02 GMT

Hi,

The problem is not in the expression, it works fine.

I need to display the list of EMPLID counted by the Expression.

Thanks,

Giampaolo

Re: Using set expression in a graph dimension

Thu, 28 Jun 2012 16:11:50 GMT

Hi everybody,

Somebody has any idea?

Thanks

Giampaolo