topic Re: Ignore always one selected field selection in expression in QlikView

Ignore always one selected field selection in expression

sibideepak — Wed, 15 Jul 2015 10:23:54 GMT

Hi ,

Here attached the application.

Questions are attached inside the qvw.

sunny_talwar — Wed, 15 Jul 2015 10:30:34 GMT

Is attached is what you wanted?

Question 1 Expression: sum(TOTAL <Date> {<Date = >}Value)

Question 2 Expression: Only({<Date = >}Aggr(Rangesum(Above(sum({1}Value)/ sum( {1}Value2),0,NoOfRows())),Date,Desc))

Best,

Sunny

sibideepak — Wed, 15 Jul 2015 10:35:31 GMT

Thanks for your answer,

Question is exactly what I want but question 2 I want to rangesum all values disregarding the dimension

here sum is discrete based on date dimension,I want the sum to be continuous

sunny_talwar — Wed, 15 Jul 2015 11:08:02 GMT

Try this expression for your second question:

Rangesum(Above(TOTAL sum({1}Value)/ sum( {1}Value2),0,RowNo(TOTAL)))