getpossiblecount and set analysis

btrompetter — Fri, 11 Dec 2009 20:41:14 GMT

Hallo,

we have a structure like this Regional Manager (RM) -> District Manager (DM)

If a DM uses the application hs NAME is selected.

I must create an Region Gross Sales Average per District. the Gross Sales from the Region devided by the number of all District Managers in the Region.

I can get the number of DM'S with the getpossiblecount(DM_NAME) but only if the DM_NAME is not selected. And set analysis didn't work in this function.

Is there a posibility to get the correct number without a VBScript at the beginning?

Thanks for help.

Bastian Trompetter

getpossiblecount and set analysis

lmonincx — Fri, 11 Dec 2009 22:02:00 GMT

Hi, have you tried to use a Count(distinct DM_Name) you can put it in a variable, once you select a region, the variable schould contain the number of DM which you can call on in your set analysis.

Hope this helps.

Linda Monincx

topic getpossiblecount and set analysis in QlikView

getpossiblecount and set analysis

getpossiblecount and set analysis