topic Re: Unique SKU Count by Region in QlikView

Unique SKU Count by Region

morab — Sat, 16 Nov 2024 03:00:51 GMT

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.

Frank_Hartmann — Sat, 13 Jul 2019 14:21:18 GMT

see attached file.

hope this helps

morab — Sat, 13 Jul 2019 14:28:38 GMT

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

Frank_Hartmann — Sat, 13 Jul 2019 14:32:28 GMT

can you describe your logic to calculate the count values?

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

Frank_Hartmann — Sat, 13 Jul 2019 14:58:19 GMT

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

see attached file

morab — Sat, 13 Jul 2019 15:34:59 GMT

Thanks a lot..