Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lus0alme
Contributor
Contributor
‎2022-01-13 03:53 AM

set analisys qlikview vs qliksense

Hi everibodies, when I use this operation inside the set analisys expression on qlikview, { < Fieldname = {'>0'} >} , it works, instead in the expression on qliksense, it doesn't work, and I need to use that: if ( Fieldname >0 outside the set analisys. Do you know the right sintax for the set analisys in the qliksense expression? Many thanks in advance Pierluca
782 Views
3 Replies
vikasmahajan
MVP
MVP
‎2022-01-13 04:25 AM 

Use this following example : =$()

Count({<G_CONTRACT_ID={"=$(vYearAvgEnrollment)>=2000"}>}Distinct G_CONTRACT_ID)

Thanks

Vikas 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
733 Views
0 Likes
marcus_sommer
MVP
MVP
‎2022-01-13 04:29 AM

That this {'>0'} worked in QlikView is a quite old bug because it's not a valid syntax to compare number against <= >= operators. The right syntax is: {">0"} with double-quotes. AFAIK it was corrected within one of the early QV 12 releases which seems that your used release is older. If you make an upgrade to a newer QV release you should see there the same behaviour like in Sense.

- Marcus

708 Views