topic Re: Override Date Selection in QlikView

Override Date Selection

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Override Date Selection

Anonymous — Thu, 13 Apr 2017 14:05:00 GMT

Hello,

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

Re: Override Date Selection

Thu, 13 Apr 2017 14:10:19 GMT

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

I can post the expressions if that helps

Re: Override Date Selection

tresB — Thu, 13 Apr 2017 14:20:31 GMT

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

Re: Override Date Selection

vinieme12 — Thu, 13 Apr 2017 15:12:22 GMT

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/