Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kicchu465
Contributor

Combination of Values

Hi Experts,

I have a requirement as below.

Sample Date:

 

CusttomerColumn1Column2Column3
A100
B110
C001
D111
E110
F001
G010
H011
I101
J000
K001
L010
M011
N100
O101
P110
Q111

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

17 Replies

Re: Combination of Values

Chekc the attached

Capture.PNG

kicchu465
Contributor

Re: Combination of Values

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

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

shiveshsingh
Honored Contributor

Re: Combination of Values

May be you can build expressions based on below expression

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

Highlighted
kicchu465
Contributor

Re: Combination of Values

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

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

kicchu465
Contributor

Re: Combination of Values

!

kicchu465
Contributor

Re: Combination of Values

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.

Capture.JPG

Re: Combination of Values

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

Capture.PNG