topic Re: How to use set analysis in QlikView

How to use set analysis

Sat, 26 Apr 2014 06:05:51 GMT

Hello

I use the following set analysis in an expression, but it doesn't work.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"},[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

It only gives as result the records : Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}

Can somebody help me ?

Thanks in advance

Marc

Re: How to use set analysis

Joseph_Musekura — Sat, 26 Apr 2014 07:13:03 GMT

Hi,

Can you please add a sample of your *.qvw?

Also what you expect as result.

Once both are added it will be easy to correct your set Analysis

/joseph

Re: How to use set analysis

MK_QSL — Sat, 26 Apr 2014 08:04:47 GMT

Your syntax is looking OK to me... Difficult to find what is going wrong.

Could you please upload your sample data file or apps?

Re: How to use set analysis

SunilChauhan — Sat, 26 Apr 2014 08:38:11 GMT

check weither data available for combination of conditions you written in set analysis

some times we dont have data for set of conditions and we thought that our expression have some problem

Re: How to use set analysis

swuehl — Sat, 26 Apr 2014 14:38:49 GMT

You can't modify the same field twice in one set modifier.

Not 100% sure what you want, it looks like you want to union two set modifier:

=Count(DISTINCT

<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>

<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}

RFQ)

Re: How to use set analysis

PrashantSangle — Sat, 26 Apr 2014 14:46:18 GMT

Hi,

As swuehl said that It is not possible to modify same field twice in on set modifier.

Then you can write two different set analysis then combine their result

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Regards,

Re: How to use set analysis

swuehl — Sat, 26 Apr 2014 14:48:43 GMT

But since you want a DISTINCT count of field RFQ, this expression might not be equivalent to mine.

Re: How to use set analysis

PrashantSangle — Sat, 26 Apr 2014 15:00:03 GMT

Hi,

Yes swuehl, you are write .

Your solution and my solution are same.

but I am just try give him more generalize solution.

That's why i reply with above solution.

Otherwise Your solution must work.

Regards,

Re: How to use set analysis

Clever_Anjos — Sat, 26 Apr 2014 17:09:55 GMT

What´s the purpose of having two conditions to same field? [Geraamde bedrag]

Re: How to use set analysis

Sat, 26 Apr 2014 17:31:21 GMT

Indeed, the only solution is to write two different set analysis as you have mentionned.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:33:45 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:33:45 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:34:21 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:34:22 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:34:57 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

Sat, 26 Apr 2014 17:34:58 GMT

The only solution is to write two different set analysis.

=Count(DISTINCT{$<[Type dossier (code)]={4},[Geraamde bedrag]={">=75000"}>}RFQ)

Count(DISTINCT{$<[Type dossier (code)]={3},[Geraamde bedrag] = {">=22000"}>}RFQ)

Thanks a lot

Marc

Re: How to use set analysis

PrashantSangle — Sun, 27 Apr 2014 05:54:52 GMT

Hi,

If you get correct answer then close thread by mark as correct answer and helpful answer.

Regards,

Re: How to use set analysis

Sun, 27 Apr 2014 06:10:22 GMT

Hello

Thank you, but my question is “How do I close the thread ?”

Thanks in advance

Marc

Re: How to use set analysis

PrashantSangle — Sun, 27 Apr 2014 06:20:31 GMT

Hi,

Select those answer which help you to solve the problem as Correct answer or Helpful answer.

If Select as Correct answer then your conversation is consider as closed.

Regards,

Re: How to use set analysis

Sun, 27 Apr 2014 06:35:35 GMT

Hello

It is done, thanks.

Marc