Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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

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]))

22 Replies

Re: Ignore dimension

Can you try this:

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

or

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

Chanty4u
Esteemed Contributor III

Re: Ignore dimension

try

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

Chanty4u
Esteemed Contributor III

Re: Ignore dimension


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

Chanty4u
Esteemed Contributor III

Re: Ignore dimension

varunreddy
Contributor III

Re: Ignore dimension

Hi Sunny,

This is not working

varunreddy
Contributor III

Re: Ignore dimension

Hi Chanty,

I want to ignore any selection for Month

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.

hcabrera
New Contributor III

Re: Ignore dimension

May be:

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


HC.

varunreddy
Contributor III

Re: Ignore dimension

Hi Henry,

Already tried this. But it is not working