topic Re: What is the correct syntax for set analysis? in QlikView

What is the correct syntax for set analysis?

Mon, 28 Jul 2014 13:52:34 GMT

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.

Re: What is the correct syntax for set analysis?

Mon, 28 Jul 2014 13:55:08 GMT

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

Re: What is the correct syntax for set analysis?

Mon, 28 Jul 2014 14:01:03 GMT

Hi Joe,

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

Re: What is the correct syntax for set analysis?

Anonymous — Mon, 28 Jul 2014 14:06:02 GMT

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

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

Re: What is the correct syntax for set analysis?

Mon, 28 Jul 2014 14:07:41 GMT

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