topic Re: Help required in getting the Contribution column based on RANK in QlikView

Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 09:44:42 GMT

Hi,

We have created the straight table as mentioned in the excel(till Sales column). Now we are stuck while creating the "Contribution" column(The formula is as mentioned in the excel). The expression of "Sales" is as mentioned in the txt file. Could you please help create the "Contribution" column?

I have put the comments in the txt file to understand the expression better. Please let me know if you have any questions.

Thanks in advance

Re: Help required in getting the Contribution column based on RANK

Anil_Babu_Samineni — Wed, 18 May 2016 10:49:36 GMT

Hello,

Can you please explain me what do you want in Contribution form. Column ..!

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 11:24:16 GMT

Same thing what i have mentioned in the excel sheet formula in the Contribution column.

Re: Help required in getting the Contribution column based on RANK

Anil_Babu_Samineni — Wed, 18 May 2016 11:30:32 GMT

So, you want to know show same output in QlikView as well...

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 11:37:49 GMT

Yes i need the same output in qlikview

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 13:23:09 GMT

Any update from any one on this?

Re: Help required in getting the Contribution column based on RANK

Anil_Babu_Samineni — Wed, 18 May 2016 13:33:00 GMT

No,

I need to ask one question. Is that data getting from Server (I mean SQL Server / DB).

If excel only, Then you can fetch same data.

That is the one i got.

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 13:41:20 GMT

Excel which I have provided is just the sample data so that somebody understand my issue and give some solution. I need to replicate the same thing in QV. I have also attached the sample of Sales expression in the txt file. Hope it is understandable now if not please let me know.

Re: Help required in getting the Contribution column based on RANK

sunny_talwar — Wed, 18 May 2016 13:44:31 GMT

qlikviewforum‌ we might be able to offer better help if you can provide us the raw data and expected results. Providing bits and pieces for a complicated problem such as yours doesn't really help much.

Check the below links and see if you can provide a sample qvw or at least raw data with the expected output

QlikCommunity Tip: How to get answers to your post?‌

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Re: Help required in getting the Contribution column based on RANK

Anonymous — Wed, 18 May 2016 13:47:53 GMT

Sum(Sales)/Sum(TOTAL <City> Sales)

Kind Regards

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 13:57:59 GMT

I got all your points Sunny. Since the application is huge and design itself is very complex I couldn't come up with a similar sample application since the granularity level should be same in my sample application as well.

But yeah i agree with you that to get the answers here we must have sample application so that everyone can understand it but unfortunately I couldn't do that for the reasons I have mentioned above.

Thanks for your valuable time and support.

Re: Help required in getting the Contribution column based on RANK

sunny_talwar — Wed, 18 May 2016 13:59:43 GMT

Have you tried looking at this link? Offers a great way to reduce the sample size and scramble any confidential data, while keeping the data model intact

Preparing examples for Upload - Reduction and Data Scrambling

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 14:03:44 GMT

I dont wish to share it in public. Is there is anyother way I can share it with you in community?

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 14:21:14 GMT

Thank you! I got your request but where do i share the qvw file privately. Please let me know that. Sorry it is very silly question.

Re: Help required in getting the Contribution column based on RANK

sunny_talwar — Wed, 18 May 2016 14:22:26 GMT

Can you send me a message or add me as a connection so that I can send you a message?

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 16:36:35 GMT

I have already received your request from you for the connection and accepted it. Can you send the message now.

Re: Help required in getting the Contribution column based on RANK

sunny_talwar — Wed, 18 May 2016 16:38:28 GMT

For me to send you a message you will have to add me as a connection. its weird, but that's how it it

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 16:41:28 GMT

Thanks this will work as per the RAW data which is in the excel but actual Sales which is attached based on that I need to create the Contribution column. Hope the requirement is understandable.

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 16:43:04 GMT

i have already added you as a connection I will try sending you message now.

Re: Help required in getting the Contribution column based on RANK

qlikviewforum — Wed, 18 May 2016 16:45:13 GMT

Message sent now please check