Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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..