topic Re: Set analysis string comparison in QlikView

Set analysis string comparison

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to write a set analysis expression to make a count of Title in a particular category

Title ID	Title	Categories	Category_1	Category_2	Category_3
1	ABC	C1\|C2	C1	C2
2	DEF	C2\|C3	C2	C3
3	GHI	C1\|C3\|C2	C1	C3	C2
4	JKL	C3\|C1	C3	C1

If Count of titles in C1 should return 3 rows, i.e. ABC, GHI & JKL.

I have used the hard-coded expression Count({1<Category= {"*C1*"}>} Title). This is returning the expected result. I want to replace this with filed Category_1.

Can anyone please help.

Thanks in advance

Re: Set analysis string comparison

Anil_Babu_Samineni — Fri, 30 Nov 2018 04:03:53 GMT

PFA, If this helps

Re: Set analysis string comparison

Anonymous — Fri, 30 Nov 2018 06:09:21 GMT

Thanks for your response. But I need C1 count as 3.

Title ID	Title	Categories
1	ABC	C1\|C2
3	GHI	C1\|C3\|C2
4	JKL	C3\|C1

These 3 rows needs to be considered

Re: Set analysis string comparison

PradeepReddy — Fri, 30 Nov 2018 06:41:10 GMT

try something like this...

Input:
Load *,
If(Wildmatch(Categories,'*C1*')>0,'Y','N') as Category1,
If(Wildmatch(Categories,'*C2*')>0,'Y','N') as Category2,
If(Wildmatch(Categories,'*C3*')>0,'Y','N') as Category3;
Load * Inline
[
TitleID,Title,Categories
1,ABC,C1|C2
3,GHI,C1|C3|C2
4,JKL,C3|C1
];

Expression..
C1: Count({<Category1={'Y'}>}TitleID)
C2: Count({<Category2={'Y'}>}TitleID)
C3: Count({<Category3={'Y'}>}TitleID)

Re: Set analysis string comparison

PradeepReddy — Fri, 30 Nov 2018 06:43:29 GMT

this solution suits, when you know the total categories in advance..

Re: Set analysis string comparison

sunny_talwar — Fri, 30 Nov 2018 13:04:50 GMT

@Anonymous wrote:

I have used the hard-coded expression Count({1<Category= {"*C1*"}>} Title). This is returning the expected result. I want to replace this with filed Category_1.

What do you mean when you say that you want to replace this with filed Category_1? You want to replace your set analysis from Category field to Category_1 field? Why? Can you elaborate on what are you exactly trying to do?