topic Re: Help with calculated dimension in QlikView

Help with calculated dimension

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

Hello all,

So i have this dimension:

=if(($(maxIndexFY_Q)-4)<=[Index_FY-Q],[Index_FY-Q])

where:

Index_FY-Q: field, it is a number for each quatrimester in ascending order from the 1st Q of the 1st Fiscal year. it has only this values : [1 2 3 4 5]

maxIndexFY_Q = maxstring({<[Index_FY-Q]=>} [Index_FY-Q]) //get the highest value of Index_FY-Q, in my case it returns 5

Somehow i can't get this dimension to work. Why? I ave done more calculated dimensions and didn't have a problem.

The objective is to represent the 5 last quatrimesters (including the current one). (can't use new script dimension)

Thanks for help ^^

Re: Help with calculated dimension

sunny_talwar — Mon, 06 Nov 2017 15:27:13 GMT

May be this

=If(MaxString(TOTAL {<[Index_FY-Q]=>} [Index_FY-Q]) <= [Index_FY-Q], [Index_FY-Q])

Re: Help with calculated dimension

Anil_Babu_Samineni — Mon, 06 Nov 2017 15:28:55 GMT

If you are calculating left hand side, You may need TOTAL keyword

Re: Help with calculated dimension

sunny_talwar — Mon, 06 Nov 2017 15:30:47 GMT

or store your variable with an equal sign (without TOTAL)

Re: Help with calculated dimension

Anonymous — Mon, 06 Nov 2017 15:42:17 GMT

This worked perfectly, i only changed it like this: maxIndexFY_Q = maxstring({<[Index_FY-Q]=>} [Index_FY-Q])

I also realized that i can use as dimension Index_FY-Q and at dimension limits restric to 5 largest! I didnt realize until now, but anyway thanks for the help!