Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shin_oomura
Contributor II
Contributor II

You can no longer specify the range in the set analysis / セット分析での範囲指定ができなくなった

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'}>} 売上)

という数式です。

どのように対処したらよいか教えていただけると助かります。

よろしくお願いします。

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

QV 12.20 requires double quotes when using advanced search syntax.

= sum ({$ <ym = {"> = 201801 <= 201807"}>} sales)


See:Quotes in Set Analysis


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

http://masterssummit.com

http://qlikviewcookbook.com

http://www.easyqlik.com