Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)))