Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Not applicable

What is the correct syntax for set analysis?

Hello all,

I try to create chart with static view for current and previous YTD.

This application have connections with Qlikview Components.

test.png

There I use two expressions:

1. TextCount($(vSetPreviousYearYTD) MARKA)

2. TextCount($(vSetYTD)MARKA)

How can I create correct expression for set analysis where select MARKA={'VOLVO'}?

If I tried to use something like TextCount({$<MARKA={'VOLVO'}, $(vSetYTD)={'*'} >}MARKA) then I got empty chart.

Tags (1)
4 Replies
Not applicable

Re: What is the correct syntax for set analysis?

Hi Dzintars,

I would take a look at this post, gives a good overview of set analysis

Set Analysis: syntaxes, examples

hope that helps

Joe

Not applicable

Re: What is the correct syntax for set analysis?

Hi Joe,

I read these doc, but anyway it not help in my situation. Thanks.

Partner
Partner

Re: What is the correct syntax for set analysis?

use Textcount({<Jahr={'$(=vSetPreviousYear)'}>}MARKA)

you need to declare which field needs to be set with the contecnt of the variable

Not applicable

Re: What is the correct syntax for set analysis?

Well, I can't see what is in your two variables, but based on the expressions you have written for 1 & 2, it looks like you have the whole set in the variables? so $(vSetYTD)={'*'} won't work in that case.

Should just be able to add MARKA={'VOLVO'} to your variable sets

hope that helps

Joe