Override Date Selection

[#1]

Hi,

I need to override the date selections on a straight table I have created. I have two dimensions and five expressions.

Expression 1 is an if statement using expression 5 as condition and a sum total

Expression 2 is an if statement using expression 5 as condition and a sum total

Expression 3 Expression1 + Expression2

Expression 4 is an if statement using expression 5 as condition and display a value

Expression 5 is an if statement taking Expression 3 from Expression 4

I think the correct way was to use a 1 instead of a $ in the expression. T

Expressions 1 and 2 need a $ or 1 as they are sums. The others calculations don't because they are calculations between expressions that already exist or don’t have any aggregation conditions.

If disable expression 3,4 and 5. Expressions are affected by the date selections in the other tabs which is what I am trying to achieve.

However, If I detach the table it seems to work without any problems, is this the best way to do it?

Thanks in advance

Dave 

[Anonymous]

Hello,

Could you post a sample data qvw in order to see the behavior directly?

[#3]

sadly not....client data is strictly confidential.

I can post the expressions if that helps

[tresesco]

You can always mimic your data using 'Scrambling', check : Preparing examples for Upload - Reduction and Data Scrambling

[vinieme12]

instead of IF() use Set Analysis and in the Set add the date field you want to ignore selections on

Example

SUM( {< Date=, FieldA= {'a'} >}  Sales)   << Here selections in Date field will be ignored.

Set Analysis: syntaxes, examples

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/