Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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..