topic Re: Combination of Values in QlikView

Combination of Values

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

Hi Experts,

I have a requirement as below.

Sample Date:

Custtomer	Column1	Column2	Column3
A	1	0	0
B	1	1	0
C	0	0	1
D	1	1	1
E	1	1	0
F	0	0	1
G	0	1	0
H	0	1	1
I	1	0	1
J	0	0	0
K	0	0	1
L	0	1	0
M	0	1	1
N	1	0	0
O	1	0	1
P	1	1	0
Q	1	1	1

I need to show in chart like,

1.How many customers have value in only Column1 but not in Column2 and 3

2. How many customers have value in only Column2 but not in Column1 and 3

3.How many customers have value in only Column3 but not in Column1 and 2

4.How many customers have value in only Column1 and Column2 but not in 3

5.How many customers have value in only Column1 but not in Column3 but not in 2 ans so on.

6.How many customers have value in all the columns.

Could you please help in completing this requirement.

Thanks

S k

Re: Combination of Values

sunny_talwar — Thu, 31 May 2018 13:26:35 GMT

Chekc the attached

Re: Combination of Values

kicchu465 — Thu, 31 May 2018 15:54:35 GMT

Hi Sunny,

The above solution is most helpful.

I my application I have 5 fields to be used and based on the above I have to write several combinations and more over I need to show them in either a bar Chart or any other chart.

Is there any other work around for this either in back end or Front end.

Thanks

S k

Re: Combination of Values

sunny_talwar — Thu, 31 May 2018 16:05:43 GMT

Can you share more info on the exact type of chart you are looking to build?

Re: Combination of Values

shiveshsingh — Thu, 31 May 2018 16:10:43 GMT

May be you can build expressions based on below expression

=count({<Column1 = {'1'},Column2 = {'0'},Column3 = {'0'}>}Custtomer)

Re: Combination of Values

kicchu465 — Thu, 31 May 2018 16:19:04 GMT

Hi Sunny,

There is no specific chart requested by the user but they wanted to see the data in better visualization.

It could be any chart other than Straight table or Pivot table.

Re: Combination of Values

sunny_talwar — Thu, 31 May 2018 16:31:27 GMT

I don't think I can give any guidance as to what you can do unless I know what you want to do...

Re: Combination of Values

kicchu465 — Thu, 31 May 2018 16:49:34 GMT

Re: Combination of Values

kicchu465 — Thu, 31 May 2018 17:02:03 GMT

Hi Sunny

The below is what user is expecting.

The Blocks represents the Column1 to Column5

The colored block indicates there is a value and empty block indicates no value.

The numbers represents the customers.

For ex:

40 Customers has values in column1 and column2 only.

Re: Combination of Values

sunny_talwar — Thu, 31 May 2018 17:14:54 GMT

For a visual, you can show this may be using Grid Chart

Re: Combination of Values

kicchu465 — Thu, 31 May 2018 18:18:51 GMT

Thanks very much Sunny.

I think this will fulfill user requirement.

I'll try this and if any issues I'll let you know.

if possible can you please attach the qvw file for my reference.

Re: Combination of Values

sunny_talwar — Thu, 31 May 2018 18:30:33 GMT

Already did... open the link to see the attachement Re: Combination of Values

Re: Combination of Values

kicchu465 — Fri, 01 Jun 2018 04:06:19 GMT

Hi Sunny,

I am facing an issue here. If I use Account Name as Dimension and in My Original app there are ~2k Customers and the Chart is looking so weird.

Any Other Suggestion.

Re: Combination of Values

kicchu465 — Fri, 01 Jun 2018 04:08:21 GMT

Hi Shivesh,

Thanks very much for the Response but if I use the above expression then I have to build the same expression for different combinations.

Thanks,

S k

Re: Combination of Values

jyothish8807 — Fri, 01 Jun 2018 05:05:35 GMT

Hi SK,

Since you have too many customers i would recommend to use a pivot table. (ref the attached).

Br,

Re: Combination of Values

kicchu465 — Fri, 01 Jun 2018 05:47:48 GMT

Hi KC,

Attachment is missing

Thanks,

Re: Combination of Values

jyothish8807 — Fri, 01 Jun 2018 08:08:02 GMT

I can see the attachment

Attached again.

Re: Combination of Values

sunny_talwar — Fri, 01 Jun 2018 08:54:38 GMT

What do you want it to show? May be add a scroll bar so that not all the customer show up at the same time?