Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

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.  

8 Replies
Not applicable

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

can any one help this its priority one for me

Not applicable

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

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

jsaradhi
Valued Contributor

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

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

Not applicable

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

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

Not applicable

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

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

Not applicable

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

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

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

Hi,

maybe like this?:

QlikCommunity_Thread_130345_Pic1.JPG.jpg

hope this helps

regards

Marco

Not applicable

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

  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