topic Re: unique value in QlikView

unique value

santharubban — Wed, 20 Aug 2014 01:14:39 GMT

Hi ALL,

We are facing some issues in our app, we need to pull distinct code for an Encounter key.

Each Diag code is have 2 different codes,

Diag code 02 is having ‘8052’ ,the same Diag is
present in the Diag _code_03. This Diag_code should consider only once
not twice because is we are getting count as 2.

pls reffere attachement

Re: unique value

sebastiandperei — Wed, 20 Aug 2014 02:25:29 GMT

Sorry, but It's very confuse....

Could you send a reduced copy of qvw? and a table with the results you need.

Thanks!

Re: unique value

santharubban — Wed, 20 Aug 2014 13:09:56 GMT

i need to show diad code only once when its repeated.

Re: unique value

ashfaq_haseeb — Wed, 20 Aug 2014 13:13:00 GMT

Hi,

Use pivot table and add dial code to dimension

Regards

ASHFAQ

Re: unique value

santharubban — Wed, 20 Aug 2014 13:19:59 GMT

no i can use pivot because after taking distinct disg code i need to compare with other table and check the matching codes.Then i need to count the match and outage counts.