Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
arvindjha2050
Creator
Creator

Set Analysis

Hello all,

 

This is with regard to set analysis :

count({$<Country = {"sum({$<Week = {">$(=$(vTest))"}>}Sales) > 1000"}>}distinct Country)

 

The double quotes doesn't  work inside the element set , with single quote output is not correct

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Hi Arvind,

Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:

count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)

View solution in original post

4 Replies
thiago_justen

What about this?

count({$<Country = {"=sum({$<Week = {'>$(vTest)'}>}Sales) > 1000"}>}distinct Country)

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
arvindjha2050
Creator
Creator
Author

Hello ,

 

thanks for the reply but this option is already tried , it returns zero instead of correct output

tresesco
MVP
MVP

Hi Arvind,

Single quotes wouldn't work for search strings. Instead try with back quote sign (grave accent) `, like:

count({$<Country = {"=sum({$<Week = {`>$(vTest)`}>}Sales) > 1000"}>}distinct Country)

View solution in original post

arvindjha2050
Creator
Creator
Author

Thanks a lot Tresesco , it works