topic Re: Help combining if statements in QlikView

Help combining if statements

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am new to programming and would be grateful for any help combining the following two statements for my Dimension Year-

=if((left(Year,6)<>'Target' AND left(Year,4)<>'Proj'),Year)

=If(GetSelectedCount(Year)=0,
If(Year >= Year(Today())-6, Year, Null()),
Year)

The first statement ignores any Years that start with the letters 'Target' and 'Proj'.

The second statement restricts the chart to showing a set number of years.

Thanks

Greg

Re: Help combining if statements

sarvesh — Tue, 21 Mar 2017 09:02:37 GMT

You have >= instead of <=

Re: Help combining if statements

Anonymous — Tue, 21 Mar 2017 09:08:15 GMT

The two statements work independently but how do I combine the two statements?

Re: Help combining if statements

sarvesh — Tue, 21 Mar 2017 09:14:49 GMT

could you share that file with me.

Re: Help combining if statements

flipside — Tue, 21 Mar 2017 09:15:31 GMT

If you've got Years with text in them, I think you would be advised to look at your data first. It sounds like you need to create a new field in your load script flagging up Proj and Target, and have the year stored as a numeric only field.

Your expressions will be easier going forward.

flipside