What is the correct syntax for set analysis?

[#1]

Hello all,

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

This application have connections with Qlikview Components.

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.

[#2]

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

[#3]

Hi Joe,

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

[Anonymous]

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

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

[#5]

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