Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
varunreddy
Contributor III

Ignore dimension

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Ignore dimension

Can you try this:

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

or

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

View solution in original post

22 Replies
Highlighted

Re: Ignore dimension

Can you try this:

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

or

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

Highlighted
Chanty4u
Esteemed Contributor III

Re: Ignore dimension

try

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

Highlighted
Chanty4u
Esteemed Contributor III

Re: Ignore dimension


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

Highlighted
Chanty4u
Esteemed Contributor III

Re: Ignore dimension

Highlighted
varunreddy
Contributor III

Re: Ignore dimension

Hi Sunny,

This is not working

Highlighted
varunreddy
Contributor III

Re: Ignore dimension

Hi Chanty,

I want to ignore any selection for Month

Highlighted

Re: Ignore dimension

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

Highlighted
hcabrera
New Contributor III

Re: Ignore dimension

May be:

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


HC.

Highlighted
varunreddy
Contributor III

Re: Ignore dimension

Hi Henry,

Already tried this. But it is not working