Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Could you post a sample data qvw in order to see the behavior directly?
sadly not....client data is strictly confidential.
I can post the expressions if that helps
You can always mimic your data using 'Scrambling', check : Preparing examples for Upload - Reduction and Data Scrambling
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/