topic Re: Exclude Fields in QlikView

Exclude Fields

smilingjohn — Fri, 30 Oct 2015 10:48:03 GMT

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 .

Re: Exclude Fields

Anonymous — Fri, 30 Oct 2015 10:51:36 GMT

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.

Re: Exclude Fields

jonathandienst — Fri, 30 Oct 2015 10:51:55 GMT

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

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

Re: Exclude Fields

smilingjohn — Fri, 30 Oct 2015 11:05:47 GMT

Thanks Rudolf