Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
morab
Contributor III
Contributor III

Unique SKU Count by Region

Hello Guys,

Please find the attached file where I have share two sheets.

1. Database (Raw Data)

2. Result (Expected Output)

I would like to request you to share .qvw with me to get my expected result by using expression.

Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

i got it. but 2 values are slightly different. are you sure your values are correct?

 

see attached file

View solution in original post

5 Replies
Frank_Hartmann
Master II
Master II

see attached file.

hope this helps

morab
Contributor III
Contributor III
Author

Thanks a lot for your prompt reply. Its not matching with the result sheet. Can you please check.

 

Frank_Hartmann
Master II
Master II

can you describe your logic to calculate the count values?

there is no excel formula in your file for the respective fields!

Frank_Hartmann
Master II
Master II

i got it. but 2 values are slightly different. are you sure your values are correct?

 

see attached file

morab
Contributor III
Contributor III
Author

Thanks a lot..