Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sibideepak
Creator II
Creator II

Ignore always one selected field selection in expression

Hi ,

Here attached the application.

Questions are attached inside the qvw.

3 Replies
sunny_talwar

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
Creator II
Creator II
Author

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

Try this expression for your second question:

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