[可视化]
怎么通过计算列的JS实现如下功能: 下拉参数控件1:值有A...
怎么通过计算列的JS实现如下功能:
下拉参数控件1:值有A、B
计算列中判断,当下拉参数1选择A时,如果指标1的值<12则返回1,否则返回-1
当下拉参数1选择B时,如果指标1的值<15则返回1,否则返回-1
|
免责声明:本文不代表本站立场,且不构成任何建议,请谨慎对待。
版权声明:作者保留权利,不代表本站立场。
|
|
|
|
yanieye
显示全部楼层
发表于 2023-12-19 20:23:24
计算列的写法:
if(param['下拉参数1'] == 'A') {
col['指标1'] < 12 ? 1 : -1;
}
else if(param['下拉参数1'] == 'B') {
col['指标1'] < 15 ? 1 : -1;
}
else {
-9999;
}
|
|
|
|
|
yhdata_SbmwkwIz
显示全部楼层
发表于 2023-12-20 08:27:35
iif(and(param["下拉参数1"]=='A',col['指标1']<12),1,0)
这样写可以吗 |
|
|
|
|
yhdata_lyaa
显示全部楼层
发表于 2023-12-20 09:54:12
|
|
|
|
yhdata_SbmwkwIz
显示全部楼层
发表于 2023-12-20 10:35:58
|
|
|
|
yhdata_lyaa
显示全部楼层
发表于 2023-12-20 10:43:08
|
|
|
|
yhdata_SbmwkwIz
显示全部楼层
发表于 2023-12-20 10:49:24
如果把上面的指标1字段换成另一个文本控件的值,该怎么写啊,直接把col['指标1']替换成文本1.data吗 |
|
|
|
|
yhdata_lyaa
显示全部楼层
发表于 2023-12-20 10:54:49
|
|
|
|
yhdata_SbmwkwIz
显示全部楼层
发表于 2023-12-20 11:40:42
本帖最后由 yhdata_SbmwkwIz 于 2023-12-20 11:44 编辑
"文本47" is not defined. ([script]#1) at line 1![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARkAAACFCAYAAABvw4ybAAAPP0lEQVR4Ae2daYsUSxaG+1/d3+E3uR9sRQRt/eACOoroaKsfxqHBXUFnBkVwGy/jgqg0XBFFHHHBvV3abdz3Xbs1hjevp25UGlVZ1RXZldn1BCSZGRl5KvLNE0+diNy6hoaGHBMa4AP4QF4+0JWXYezitPgAPiAfADJEckSy+ECuPgBkcLBcHYxohmgGyAAZIIMP5OoDQAYHy9XBiGSIZIAMkAEy+ECuPgBkcLBcHYxIhkgGyAAZIIMP5OoDQAYHy9XBiGSIZIAMkAEy+ECuPgBkcLBcHYxIhkgGyAAZIIMP5OoDQAYHy9XBiGSIZIAMkAEy+ECuPgBkcLBcHYxIhkgGyAAZIIMP5OoDQAYHy9XBiGSIZLq+fP3qmNAAH8AH8vKBrrfvPzomNMAH8IG8fKDLkVAABVAgRwWATI7iYhoFUMA5IIMXoAAK5KoAkMlVXoyjAAoAGXwABVAgVwWATK7yYhwFUADI4AMogAK5KgBkcpUX4yiAAkAGH0ABFMhVASCTq7wYRwEUADL4AAqgQK4KAJlc5cU4CqAAkMEHUAAFclUAyOQqL8ZRAAWADD6AAiNQYHh42LUyff36dQS/Ws5dgEyJztu5c+fc9evXmdqswf37912r52JgYMC9ePGiRN438qoCmZFrN+p7CjCk9ivw9u3bBPSt1OTly5fu6tWrrZgozb5ApjSnyrXs2CU61EJXNQZkYtgotEhe5YCMJ0bRF4lkinGGYgAiho1iqJFdCyCTrVFhSgCZYpyKGICIYSNvNfSlCdWz1vTu3buGqtCxkDl58qR7/Pix2717d9I37u/vdwcOHEgG9BpSrg2FgEwbRA/8ZAxAxLARqFq0LAHm7Nmz7sqVKzWnixcvugcPHmT+ZsdCZnBw0B08eDCBjODy6dMnt2fPHvfq1auKaMoThASjGTNmuHHjxlVNusKgMn19fU72NAlWStomu0obN26s2q+7uzuxqzIqr/0aSfUgo3oLnLKpScdy586d5LdVR0t2TJZXdLBavYs0jwGIGDby1ET1E2Bev35dc3r06JG7du1aZjU6EjJqYL29vVUNX6Dw89atW1dZF2C03RqmVLXGrDyBQiAxyKjBy5YPLAOYQcX2t/XMM+WyB371G7Jn0ZnVx7etPB1LCJqCX6PA82122nIMQMSwkafusSCj9tGRkLGTo0hGDU6TLidu3bo12WRAkED1Ipnjx48HG6sf8dQqIygJNAYZW7e6heb1IhnZ8n/XoiXLM4BY5KK5bbO5bJCyFagFiLt377rbt2+779+/J0Y017ry06mWjXS5dq0DmRaVFzwUaah7IYhorn92LSv60FxlrJzKhv75Fy1a5Hp6epLGqkbrRw7W6JUvO4KIbBtU7BDS65YfmteDjMrr9wXKefPmJQDTsvKsXqqHgGrrmltSfYGMqVF/XgsQ0lddDN1o9+XLF3fz5s1kXfnpVMtGuly71mNBRvXvyEhGjd2Hhv3Lq5EJMGr4VkaA0ZiMohsla6Chk69tsqXIQPuZc1n0oH1k1yIl1UGT8hpJ9SCjuhs4BU0tW4RmANHcjpVIphHFw2XqAeLz589JVHz+/PlkrvVQqmcjVH6084BMBMUtghAILMpQY58/f34CEv2Etgk66kqpwfpgEkhqdYWs+6G5RTgGH3+blmNBJg0NHZPVXxGNjk0DwToewTBdXnURhEjZCmQBQldmnjx54jSvlbJs1NpvtPKBTASl1QD1b2+Ny9bV1VADVbJGatGNRTPapkbqN0o1XAFKDdr2D1XTIpn0Nu3j20tv13q9SMa3Kzuqn5Lmfn0Mrja339E+Wb9vZTt9HgMQMWzkeR5iQebNmzed2V3SyTGoCAoWoVgj09yuLhk4Qpex/UjG7x5pf4tYVq9eXbFveem5D4F6jlMPMtrPftfqonVFUAKnIKhkcCGSqad0/W0xABHDRv1atrZVN9rpPhhdpq416UHRLJ9ULTpyTEaAsQHQRk+FHylon3Qk06idVsplnVBBRcAUOAUyg41/vIKMIrM06GxdNkj1FYgBiBg26tey9a260U73wdSa5I+N3PXbkZBpXf72WKgHmRs3brh9+/a1p2Id9qsxABHDRllkBzJlOVMZYzIlOozSVzUGIGLYKIuQQKYsZwrIFOZMxQBEDBuFESSjIkAmQ6AibdaNXrrvgqm9GuiFUzoXAsVIJ3Vv7927VyT3yq0uQCY3aeMb1uCz7r9gaq8GutoiyGiMbKSTrsx0ynt+gUx8FmARBVDAUwDIeGKwiAIoEF8BIBNfUyyiAAp4CgAZTwwWUQAF4isAZOJrikUUQAFPASDjicEiCqBAfAWATHxNsYgCKOApAGQ8MVhEARSIrwCQia8pFlEABTwFgIwnBosogALxFega6bMXZduvkfdexJcXiyiAAl0jffaibPvpWZNGvnaHS6AACsRVoGO6S4q8BEYSCqDA6CoAZEZX71L+2vDwcCnrTaWLoQCQCZwHPYKvr0teuHAhsLV4WZcuXXLbtm1zz549i145vW1+7ty57tChQy3Zvnz5sjtx4oT79u1bxc6HDx8SnfXqimaT9t25c6fbsmWLO3bsWNXuWle+tqscqb0KAJmA/vYlA/usSKBIobL08u/p06c7vUwpdjp16pSbMmVKS+NZL168cEuXLg3aEHjWrFnjmo2W9G4dvTR9x44d7tatW1WHrXXlN/NNqyoDrERVAMgE5CwjZPJoUGr4+jSMpmYh4Mt69OhRt2nTpso3ov1tipQWLlyYfNLVz89aNsjU+rqCfblB5UjtVQDIBPQvOmT0RUv9UytCUPIblD7yrlc76rMoasCtJF2NUxSjaGakSV3PlStXujNnzgRNqL4CULNRI5AJylnITCDjXPIPq/GX06dPJ5NC+NmzZ7v169dX8rQtHZZnndG7d+8mYwMaH6g3qVwzSeNF48ePT76dNHPmzKSekydPdhs2bHCa6xtKU6dOrXzQrRnbftm9e/e6OXPmtAQrgW7BggXu9u3bvumqZQGm0Q/c2Y5AxpQo/hzIOJd0BZYsWZL04dXt0PiGGvHEiRMrecrfvn17U2dUg53aL2tSuWaTui+KNBTRTJo0KQGLBmg16KkGqAihlSQ4CDACTStJdfG/Lx6yBWRCqoydPCATOJdF7y75VVaEoKhl1qxZbsWKFdGuppw9e7blAV/V07Ssd6Vu165dSffOP66sZSKZLIWKsx3IBM6FNYxmxwkCpnLNev78edKtU1dM3+pWF0/LrQzSqsI24Ltq1aqWbcmexocEklCS1suWLXOCWjMJyDSjVnvLApmA/mWAjO7/UOSiKzP2XJbuaJ4wYUJy70kr3aUYA76+rIODg27x4sXBsR3Vefny5ZVj8Pertwxk6qlTrG1AJnA+ygCZ9+/fu82bN1cNqAoshw8fdkeOHGlpTCbGgK8vq+q1Z88et3///qp66crT6tWrm45iZNsgo0Hu9KCx1pWvsTCVI7VXASDTXv0L9+sCgu4cvnbtWuHqRoXKqQCQKed5o9YoUBoFgExpThUVRYFyKgBkynneqDUKlEYBIFOaU0VFUaCcCnTM6zf1nM/AwEDwLJXtVaLU961Dg/JoMLZfvzkwkIBF92LoocJa71uRw965cyf3SfUownT1+oCLPRXhuKhDMfwrfR7GZHdpaGjI3b//wOm9vpr0VLLetaKDDyWDjG5wy2v6/Plz6Kfbkjf83bl3X+JNH4fachj8aEkUGHOQ0X0eL1+9rgDGQKNIBcj84ZVApiStc4xUc8xBRs/dPH367CfI6DUNRYOMbrfv6+tLHiLM8ie9MybWs1RAJktttsdUYMxBZmhodCGjW/DXrl2b2c2q1V1q9DUHDUFm3jzntmz5wz+03NVVPf3+e7ItDZnnbz65Nes3ugdPX9XsRv37Pwfcyf+eC26nuxSzSY49W0DGueRKhbpTzYzHPHz40PX09CRvfdOTz1n7fvz40fX29ibP1Oi5mnrTtGnTnKZ6ZbStu7v7zxdTXbni3K+//gkZ31f1gnFB58dLtYGMLw7LeSsAZEYIGYOKrlo1Ahk/ktHDgukH97SuB/v0cGY62cOANR/4EzwEEb1OwSIZ34jyfkQxyhZkFLX0TJ+RgGzuX+a7v/29L8m7PDDoJnR3J/narnKKYgx4injSZR494yFEX26WqxUAMm2ATKjro25TaMxF0BF8+vv7k/eyBEEkwAgimtKQSUUxBhnBQvDQVSZBQ6BJd5fUPbIytbpLKvPbvgPVXsUaCngKAJk2QEbg0ICvBn6VakUxfjkD00+DxYKKgSUEGX/7jxP//OUr99clvRWopMdkBCA/chGI0pDxy6xdv9FzKRZRoFoBINMGyOgUCCwaoxE81A0y4Njp0bqfb5DRdtt2T2+T++WX6sFdDfYadNSNmjbNOY3XeKkeZAQTi14U4Wz+59Yk2vEhky7zj39t9ayziALVCgCZNkFGp0HgqBq8/XFuLFrRKzUFGosqbC44aSzIh1CyazqSEVwEmR8Dvga2/z16nEQydrXI7y4pQrF8wUTr6UgmXYZIprpRsVatAJBpA2Q09iJg2PiKXXUKjcnY6fIjGcv7aZ6GjNY1XvMjGWQUyQgsNsBba+BXg8EWyVh5AcaWdQwqQyRjCjMPKQBkWoSMXWXKmvuXsGvBxOAj6KSvMjUEmdAZDuSlL2G3+ogB98kERCarogCQGSXI+JewK+q3aQHItEn4Dv1ZINOhkFH0EXPq0PbDYTegAJDpQMg04BcUQYFoCgAZIBPNmTCEAiEFgAyQCfkFeSgQTQEgA2SiOROGUCCkAJABMiG/IA8FoikAZIBMNGfCEAqEFAAyQCbkF+ShQDQFgAyQieZMGEKBkAJABsiE/II8FIimAJABMtGcCUMoEFIAyACZkF+QhwLRFAAyQCaaM2EIBUIKABkgE/IL8lAgmgJABshEcyYMoUBIASADZEJ+QR4KRFMAyACZaM6EIRQIKQBkgEzIL8hDgWgKABkgE82ZMIQCIQWADJAJ+QV5KBBNASADZKI5E4ZQIKQAkAEyIb8gDwWiKQBkgEw0Z8IQCoQUADJAJuQX5KFANAWADJCJ5kwYQoGQAkAGyIT8gjwUiKYAkAEy0ZwJQygQUgDIAJmQX5CHAtEUADJAJpozYQgFQgoAGSAT8gvyUCCaAkAGyERzJgyhQEgBIANkQn5BHgpEUwDIAJlozoQhFAgpAGSATMgvyEOBaAr8HxgNDxSvt43EAAAAAElFTkSuQmCC)
|
|
|
|
|
yhdata_lyaa
显示全部楼层
发表于 2023-12-20 13:09:43
那试试先在脚本里先把它赋值给参数吧,
param['a']=文本1.data |
|
|
|
|