topic Re: Alternate State , If condition in QlikView

Alternate State , If condition

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

Hi ,

I have a expression.

=If(Fin_Months='Jan' or Fin_Months='Feb' or Fin_Months='Mar','1Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Apr' or Fin_Months='May' or Fin_Months='Jun','2Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Jul' or Fin_Months='Aug' or Fin_Months='Sep','3Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Oct' or Fin_Months='Nov' or Fin_Months='Dec','4Q'&(Right(Fin_Years,2)-1),

))))

This works good when i keep it in text box , but when i keep it in variable it doesnt provide any output.

I want to use this where Fin_Months and Fin_Years are in different alternate state.

Data format Fin_Months and Fin_Years is text.

Any help would be appreciated.

Anonymous — Tue, 22 May 2018 09:30:47 GMT

Are you calling the variable correctly like this ? $(YOURVARIABLE)

sunny_talwar — Tue, 22 May 2018 11:36:39 GMT

May be just wrap it around with Only function and give it a alternate state in the set analysis

=Only({AlternateState}

If(Fin_Months='Jan' or Fin_Months='Feb' or Fin_Months='Mar','1Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Apr' or Fin_Months='May' or Fin_Months='Jun','2Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Jul' or Fin_Months='Aug' or Fin_Months='Sep','3Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Oct' or Fin_Months='Nov' or Fin_Months='Dec','4Q'&(Right(Fin_Years,2)-1),

)))))

sunny_talwar — Tue, 22 May 2018 11:51:14 GMT

Also, you might want to simplify your expression like this

Only({AlternateState}Ceil(Month(Date#(Fin_Months, 'MMM'))/3) & 'Q'&(Right(Fin_Years, 2)-1))

shiveshsingh — Tue, 22 May 2018 13:08:02 GMT

Can you try this

=only(If(Fin_Months='Jan' or Fin_Months='Feb' or Fin_Months='Mar','1Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Apr' or Fin_Months='May' or Fin_Months='Jun','2Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Jul' or Fin_Months='Aug' or Fin_Months='Sep','3Q'&(Right(Fin_Years,2)-1),

If(Fin_Months='Oct' or Fin_Months='Nov' or Fin_Months='Dec','4Q'&(Right(Fin_Years,2)-1),

)))))