Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
You can no longer specify the range in the set analysis
Since PC changed from 32 Bit (Windows 7) to 64 Bit (Windows 10), we installed QlikView on a new personal computer.
Installed version: November 2017 SR6 (12.20.20700.0)
Then, it has become impossible to do the set analysis of the form that specifies the range that was moving until now.
In particular,
= sum ({$ <ym = {'> = 201801 <= 201807'}>} sales)
That is a formula.
It will be helpful if you let me know how to deal with it.
Thank you.
Note: English translation included by Community Moderator as a courtesy. Please post using English except in dedicated language groups.
----------------------------------------------------------------------------------------------------------------------------------------------------
パソコンが32Bit(Windows7)から64Bit(Windows10)に変わったため、QlikViewを新しいパソコンにインストールしました。
インストールしたバージョン:November 2017 SR6(12.20.20700.0)
すると、今まで動いていた、範囲指定する形のセット分析ができなくなってしまいました。
具体的には、
=sum({$<ym={'>=201801<=201807'}>} 売上)
という数式です。
どのように対処したらよいか教えていただけると助かります。
よろしくお願いします。
QV 12.20 requires double quotes when using advanced search syntax.
= sum ({$ <ym = {"> = 201801 <= 201807"}>} sales)
You can force a document to use the old behavior for single quotes by adding this as the first line of your script:
///$sqs old
See the Nov 2017 Release Notes for more info.
-Rob