Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Exclude Fields

HI All ,

I just want to ignore the filter (FILED) selction for my chart

and my expression is

=Round(sum({<PERIOD_NAME =>}EXTENDED_AMOUNT_IN_INR)/((Today()-('01-04-' & (max(PERIOD_YEAR)-1)))*(('01-04-'& max(PERIOD_YEAR)))-('01-04-'& (max(PERIOD_YEAR)-1))))/

sum({<PERIOD_NAME =>}ITM_VALUE)

after implenting this the filter PERIOD_NAME is still affection the values , Can please someone modify this .

When i use just  sum({<PERIOD_NAME =>}EXTENDED_AMOUNT_IN_INR)

for this expression it ignore the Filed selction PERIOD NAME .

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Exclude Fields

you may need to provide the set Analysis with ignore field PERIOD_NAME as well for the data functions

max({<PERIOD_NAME =>}(PERIOD_YEAR)-1) etc.

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Exclude Fields

you may need to provide the set Analysis with ignore field PERIOD_NAME as well for the data functions

max({<PERIOD_NAME =>}(PERIOD_YEAR)-1) etc.

View solution in original post

Highlighted
MVP
MVP

Re: Exclude Fields

I expect you need to include the override for PERIOD_NAME in all the Max() statements as well

..... max({<PERIOD_NAME=>} PERIOD_YEAR) .....

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator III
Creator III

Re: Exclude Fields

Thanks Rudolf