topic Re: Count of two columns output in QlikView

Count of two columns output

Mon, 22 Jun 2015 07:37:11 GMT

Hi All,

I required Output for the below columns as z= 1/6;

here is the table for the seven dates

x- sum of x;

y- count of distinct date where content= null

so my output should be z=x/y as z=1/6;

Thanks in advance

Avinash

swuehl — Mon, 22 Jun 2015 09:29:48 GMT

How does your resident table in your data model looks like? I assume above is kind of a chart layout?

And you are looking for y: count of distinct dates where content is not equal null, right?

Is 'null' a text value or a NULL in the resident table?

And you want the output in a text box?

You can look into some functions that might help you here:

sum(), rangesum(), isnull(), nullcount()

Mon, 22 Jun 2015 10:53:35 GMT

thanks for your reply.

Actually i want this output in table box for a field. I got it through using sum.