Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I am trying to create 1 application in which when nothing is selected, my minimum and maximum, is equal to my maximum and to be able to use in a set analisys.
this is what i want but with no selection:
i don't want the Record with "100" in Factkey:
i have tried with something like this but with no sucess
let vMinFactDate=if($(vSelected) = 0,'"%(=max(FactKey))"','"%(=min(FactKey))"');"
can you help me ?
a small apllication in attach
thanks in advance
Ricardo
I might be wrong, just check this may be?
See attached.
thanks
It works but what I wanted was to change the contents of the variable vDisplayMinFactDate because I have many set analisys expressions that use it.
it's possible ?
Can you elaborate please. I did not change any variable values in that file. Can you give some examples?
i want to use the variable (for instance) "vOldValue"
where :
let vOldValue='sum({<FactKey={'& chr(39) & chr(36) &'(vDisplayMinFactDate)'& chr(39) & '}>} #Value)';
so i want to change the variable "vDisplayMinFactDate" depending on the selection.
"Min value" if i have anyting selected
"Max value" if i dont have any selection.
Now it's clear to you?
Regards
Ricardo
I'm a little confused but does this get you what you want?
let vDisplayMinFactDate=if($(vSelected)=0,max({1<FactKey = {"$(=max(FactKey))"}>} FactKey),min({1<FactKey = {"$(=min(FactKey))"}>} FactKey))
Where do you want to display those? Can you replicate your output you are expecting when you select and when you don't ? The variable should function based on selections. No changes were done to them.
Wallo
i got "Syntax error
Unexpected token: 'GetSelectedCount', expected nothing
let vDisplayMinFactDate =if(=>>>>>>GetSelectedCount<<<<<<(FactKey)=0, max({1<FactKey = {""}>} FactKey), min({1<FactKey = {""}>} FactKey))"
i want to have a lot of expressions using a variable depending on select.
let vOldValue= 'sum({<FactKey={'& chr(39) & chr(36) &'(vDisplayMinFactDate)'& chr(39) & '} >} #Value)';.
.