Hi, I am completely new to Qlik and trialing it for my workplace. I did the below chart in excel from a summarised table. An example of the raw data is shown in the table below. I am an excel and Tableau user an am struggling to create this in Qlikview

[#1]

[#2]

What I am trying to do is plot counts of var1, var2 and var 3 by the legend value as above.

One of the things I am trying to plot is where var 1 is > 0.  I have made some progress but the zero's are still being included.

This is what I have in my conditional statement in the expressions tab: count([#var1]> 0) but it isn't working.

Below is where I am at with my chart which is still including zero values.

[vikasmahajan]

attach your data source it can created in qlik

Vikas

[#4]

Hi,

Please share the data file.

[jagan]

Hi,

Can you attach some raw data so that it would be easier to provide the solution.

Regards,

jagan.

[petter · Accepted solution]

It is something like this you had in mind then? I created two calculated dimensions for Vars and Answers (yes/no) and just made some random numbers to show for each value since I don't have any data source to use:

[#7]

follow the below  process

1)New sheet Objects-->Charts-->select bar chart 

2)click next-->add dimension(Field of(Var1,var2,var3))

3)add two expressions-->>=yes   and select value on data points

                                   -->=No     and select value on data points

[#8]

Hi, just trying to load the data but can't see how to, sorry.

I am trying to measure if an email sent affected var1, var2 and var3 

var1 - I only want counts of values > 0

var2 and var3 - I only want counts of 'Y'

I also will have a list box for status which I will be filtering on.

Here is the data sample again:

ID	Cell Name	Status	var1	var2	var3	Opened Email
1	M02	7	6	N	N	N
2	M01	7	5	Y	N	N
3	M01	7	5	Y	N	N
4	M03	7	0	N	N	N
5	M01	7	18	Y	N	N
6	M01	7	3	N	N	N
7	M01	7	51	Y	Y	N
8	M02	7	6	Y	N	Y
9	M05	7	2	Y	N	N
10	M02	7	4	Y	N	N

[#9]

Hi, thanks for your response.  Please see my comments above to Petter.

The Yes/No is derived from another variable and I have conditions for my counts.

[#10]

Sorry, cant see how to attach it.