topic Re: Variable question in QlikView

Variable question

ecabanas — Wed, 02 Mar 2016 15:10:47 GMT

Hi,

I have a set analisys:

sum({<CalendarMonthName=>}Revenues)

I want to replace CalendarMonthaName by a Variable. This variable could be CalendarMonthName_C= or CalendarMonthName=

Anyone could help to me?

Many thank's

Eduard

Wed, 02 Mar 2016 15:17:36 GMT

Hi,

Can't you use a boolean Variable(True/False) and use it like that:

if(Variable=True, sum({<CalendarMonthName=>}Revenues),sum({<CalendarMonthName_C=>}Revenues)

Philippe

ecabanas — Wed, 02 Mar 2016 15:43:29 GMT

yesss many thank's Phillipe

Wed, 02 Mar 2016 15:45:20 GMT

You're welcome