topic Re: Ignore dimension in QlikView

Ignore dimension

tmumaw — Thu, 18 May 2017 15:13:14 GMT

Hi all,

I am trying to ignore a dimension on one of my pivot tables. See the attached images:

The column in the pivot table labeled Avg Emps should be the same as the one above. How can I ignore the action in the bottom chart?

thanks

Re: Ignore dimension

Anil_Babu_Samineni — Thu, 18 May 2017 15:19:55 GMT

You can do like below

Sum({<Action=>} [Avg Emps])

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 15:22:54 GMT

That works if you want to ignore what the user selects.

Re: Ignore dimension

Anil_Babu_Samineni — Thu, 18 May 2017 15:25:59 GMT

You are ignoring only one variant only. Could be there must be another variant which is associate on the table. If not, Then just for identify, You mentioned ignore. What does the use on your application?

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 15:41:46 GMT

The 542 is the total for the company. I need to measure the emp count to the company total by action.

Re: Ignore dimension

Anil_Babu_Samineni — Thu, 18 May 2017 15:53:17 GMT

May be this?

Sum(TOTAL <Action> [Avg Emps])

If not I would suggest you to provide sample

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 16:02:04 GMT

Check this out.....

Re: Ignore dimension

Anonymous — Thu, 18 May 2017 16:16:04 GMT

Sum(TOTAL <Year> [Avg Emps])

Re: Ignore dimension

Anil_Babu_Samineni — Thu, 18 May 2017 16:22:12 GMT

Seems, You don't have data for this - 26 / Davey Layoff

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 16:23:11 GMT

Nope

Here is the statement:

Sum(TOTAL <FISYR> EmpCt_ZEMPCT) / Count({<EmpDays = {1}>}DISTINCT(Date_ZWKDATE))

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 16:25:53 GMT

There are 2 employees which have a 26. The column labeled Avg Emps should be 542 on 24, 26 and 27. I want to calculate the % to total avg emps.

Re: Ignore dimension

Anonymous — Thu, 18 May 2017 16:26:50 GMT

Sum(TOTAL EmpCt_ZEMPCT) / Count({<EmpDays = {1}>}DISTINCT TOTAL(Date_ZWKDATE))

Re: Ignore dimension

Anil_Babu_Samineni — Thu, 18 May 2017 16:30:05 GMT

There is no data for 26 in EmpCt_ZEMPCT. Could be fault over there?

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 16:32:58 GMT

Thanks Wallo......works perfect and thanks Anil.....for your help

Re: Ignore dimension

tmumaw — Thu, 18 May 2017 17:03:38 GMT

Wallo,

Works great for 1 year being selected, however when I un-filter on the year I get this:

Re: Ignore dimension

Anonymous — Thu, 18 May 2017 18:38:31 GMT

Try

=aggr((Sum(TOTAL <FISYR> EmpCt_ZEMPCT) / Count({<EmpDays = {1}>}DISTINCT TOTAL<FISYR>(Date_ZWKDATE))),FISYR,Action)

Re: Ignore dimension

tmumaw — Fri, 19 May 2017 11:16:53 GMT

Thanks Wallo. This was what I was looking for. Have a great weekend.

Re: Ignore dimension

Anonymous — Fri, 19 May 2017 15:11:46 GMT

Glad it works for you. You have a good weekend too!