Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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..