topic requirement in QlikView

requirement

Anonymous — Thu, 26 Jul 2018 10:26:49 GMT

I have an expression:

num(count({$}distinct id)/count({1}total distinct id)),'###.%')

now my id has been split into two: id1 and id2 ,so what will be the correct syntacx to write this

Re: requirement

thevingo — Thu, 26 Jul 2018 10:42:24 GMT

can you elaborate

Re: requirement

Anonymous — Thu, 26 Jul 2018 10:51:45 GMT

=num(

count({$}DISTINCT id1)/count({1}total DISTINCT id2)+count({$}DISTINCT id1)/count({1}total DISTINCT id2)

,'###.%')

is it a correct syntax ?

Re: requirement

Anonymous — Thu, 26 Jul 2018 11:13:34 GMT

can anyone help on this?

Re: requirement

thevingo — Thu, 26 Jul 2018 12:19:08 GMT

may be stalwar1‌

Re: requirement

sunny_talwar — Thu, 26 Jul 2018 12:26:28 GMT

So let me understand this... you had this

and now it is like this

ID1, ID2

1, -

2, -

-, 3

-, 4

Re: requirement

Anonymous — Thu, 26 Jul 2018 12:56:18 GMT

both ids have the value,

its just that ist been segregated on the basis of some type,

where as in id1+id2 =total id value

I just need to cross check on my set analysis expression

Re: requirement

sunny_talwar — Thu, 26 Jul 2018 13:00:07 GMT

Hahahaha, I am not sure I understand... is it possible to demonstrate what change with an example (just like how I showed what I interpreted)?

Re: requirement

Anonymous — Fri, 27 Jul 2018 08:09:47 GMT

your understanding is correct,its like that only

how to write the syntax now?

Re: requirement

sunny_talwar — Fri, 27 Jul 2018 11:09:49 GMT

Try this may be

Num(Count({$}DISTINCT Alt(id1, id2))/Count({1}TOTAL DISTINCT Alt(id1, id2)), '###.%')

Re: requirement

neelamsaroha157 — Fri, 27 Jul 2018 18:58:51 GMT

You can also create a field by concatenating these two IDs in the script and count that field in front end while keeping your initial expression same.