topic Re: Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer in QlikView

Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Thu, 21 Aug 2014 18:09:57 GMT

Distinct Counts of two sources (ABC & DEF)which has some dimensions There is no Association b/w them along with count of number of rows of each table. And Count number of times that distinct value or code is repeated from each dimension, display them separately.

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Thu, 21 Aug 2014 18:34:11 GMT

can any one help this its priority one for me

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Thu, 21 Aug 2014 18:51:23 GMT

Can you add an example of what you would want the output to be? I am not sure what you are intending to count.

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Anonymous — Thu, 21 Aug 2014 18:57:55 GMT

your expected output is not clear from your description. can you update your spreadsheet to include expected result?

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Thu, 21 Aug 2014 19:04:05 GMT

I Need to display the ABC & DEF tables with 8 columns in Excel .say in DEF table curr column has 001 & 064 i need to display as 2 in output same for all other columns

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Thu, 21 Aug 2014 21:06:57 GMT

Can you post another spreadsheet with the output table you are envisioning?

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Sun, 24 Aug 2014 17:51:25 GMT

Lets say there are two currency code,005 & 006,so how many times these two are repeated?How many distinct values in Amount ,so how many times the values repeated?

Sample data as

Currency Amount

005 1000

006 2000

006 3000

005 2000

005 4000

005 5000

Expected o/p:Currency 005- 4 times

006- 3 times

Amount:1000-1 time

2000- 2 time

3000-2 time

4000-1 time

5000-1 time

Re: Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

MarcoWedel — Sun, 24 Aug 2014 18:08:58 GMT

Hi,

maybe like this?:

hope this helps

regards

Marco

Re: Distinct count of two Tables with no association the individual dimension count,number of rows to be displayer

Mon, 25 Aug 2014 08:10:26 GMT

Distinct Counts of Amount and Currency dimensions along with count of number of rows of each Column. And Count number of times that distinct value or code is repeated from each dimension