Qlik Community

App Development

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

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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