Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have one requirement, I have one field Month which contains negative and positive values like -19,-15,-6,-3,4,5...
I have one text box If i click text box then it should select the values from -15 to -3 in 'Month' field.
I have tried many ways if it is a positive value it's working fine but here i need to select negative value that's why i'm unable to select those values -15,-14,-13,-12,-11,-10,-9,-8,-7,-6,-5,-4,-3.
Could you please anybody have a look into this?
i'm attaching sample QVW also.
Thanks,
Sekhar
Try using this for your search string in your Text Box action
<=-3>=-15
I think you don't need fabs here and also made other minor changes to your select in field expression:
='('& Concat(Distinct If(Month<=-3 and Month >=-15,Month), '|') & ')'
Also attaching your application for reference. (PFA)
Best,
Sunny
In
select in Field
Field as Month
Search string <0
then if you select then it shows only negative values .
see attached
Hi Sunindia,
Thanks for reply. It's working for me.
I have used ='('& Concat(Distinct iF(Month<=-3 and Month >=-15,Month&'|'))&')' that'swhy i'm getting error.
Thanks,
Sekhar