topic Re: Ignore dimension in QlikView

Ignore dimension

varunreddy — Thu, 07 Apr 2016 16:54:03 GMT

Hi Guys,

I have created a bar chart.

Dimensions used:

Month

CDE Name

Expression Used:

aggr(sum(Failing Records),CDE,Month)

This is working fine. When I select a Month, the report is displaying data for one particular month. I want to ignore selections based on Month.

Is this possible?

Thanks in advance!

Kind Regards,

Varun

Re: Ignore dimension

sunny_talwar — Thu, 07 Apr 2016 16:56:18 GMT

Can you try this:

Sum({<Month>} [Failing Records])

Sum({<Month>} Aggr(Sum({<Month>} [Failing Records]), CDE, Month))

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 16:56:36 GMT

try

Only({<Month-={'Monthname'}>}Failing Records)

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 16:58:59 GMT

=Only(aggr(Total <Failing Records>),CDE,Month)

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 16:59:39 GMT

chk dis

Ignore all selections except some specific fields using Set Analysis

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:01:45 GMT

Hi Sunny,

This is not working

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:02:59 GMT

Hi Chanty,

I want to ignore any selection for Month

Re: Ignore dimension

sunny_talwar — Thu, 07 Apr 2016 17:03:04 GMT

Would you be able to show a sample showing the issue? There is not other way I can think of ignoring selections.

Re: Ignore dimension

hcabrera — Thu, 07 Apr 2016 17:04:35 GMT

May be:

aggr(sum({<Month=>}Failing Records),CDE,Month)

HC.

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:05:52 GMT

Hi Henry,

Already tried this. But it is not working

Re: Ignore dimension

sunny_talwar — Thu, 07 Apr 2016 17:07:49 GMT

Just saw this good blog which talks about how images can help you get to your desired result. Same goes for the sample. It would be much more efficient if you can provide a sample my friend.

A picture is worth a thousand words

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 17:08:17 GMT

try this

=aggr(sum (Total [Failing Records]),CDE, Month)

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:11:45 GMT

Hi Sunny,

Hope this works

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:12:21 GMT

Chanty,

Not working.

Thanks for your help though

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 17:12:46 GMT

generally

To ignore dimension in Aggr:

Example:

Aggr(Sum(value), dim1, dim2 <dim3, dim4>) where dim3 and dim4 are the dimension you need to be excludeed

Re: Ignore dimension

sunny_talwar — Thu, 07 Apr 2016 17:14:13 GMT

Can you try this:

Sum({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))

Only({<Report Date]>} Aggr(Sum({<Report Date]>} [Ruleset Failing Records]), [CDE Name], [Report Date]))

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 17:14:25 GMT

try this

it will work

sum({1<Month= >} [Failing Records])

Re: Ignore dimension

Chanty4u — Thu, 07 Apr 2016 17:23:07 GMT

may be

count(TOTAL <Month> [Failing Records])

Ignore selection in Dimension: count({$<Month=>}[Failing Records])

Ignore All Dimensions in chart: count(TOTAL [Failing Records])

Re: Ignore dimension

varunreddy — Thu, 07 Apr 2016 17:49:01 GMT

Hi Sunny,

This is working. Can you explain what is the difference between this and the equation I wrote

Re: Ignore dimension

sunny_talwar — Thu, 07 Apr 2016 17:51:03 GMT

Although you don't specify an outer aggregation function (such as Only or Sum or Min or Max), there is a outer aggregation that is out there. In your case Only(). If you are using a set analysis to ignore something in your inner aggregation, you need to do the same on the outer aggregation as well, else the results will be what you saw in your case.

Hope this clarify things?

Best,

Sunny