topic Re: How to implement the below report in Qlikview....?? in QlikView

How to implement the below report in Qlikview....??

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How to implement the above inserted report in qlikview. Could you please provide the solution for that and find the below details for the report.

% On Count	Instant Count +CHQ Count /Total Count
% On Amount	Instant Amt +CHQ Amt /Total Amount
Instant	Single dimension Values
CHQ
DD
Online

Please find attached sample data as well.

Thanks & Regards,

Subbu

Re: How to implement the below report in Qlikview....??

varshavig12 — Thu, 10 Nov 2016 11:54:23 GMT

Try not to post the same question again,

How to implement the below report in Qlikview??

Re: How to implement the below report in Qlikview....??

MK9885 — Thu, 10 Nov 2016 13:56:21 GMT

% On Count	Instant Count +CHQ Count /Total Count
% On Amount	Instant Amt +CHQ Amt /Total Amount
Instant	Single dimension Values
CHQ
DD
Online

In the above table you need % On Count as Instant Count+ CHQ Count/Total Count but I don't find any field named Count.

Only measure is Amount in the data you've provided and please explain how do you plan to get the % On Count, % on Amount?

What expressions you using in your XL file for this? And also the Dimensions not match with the names you've give in table.

Re: How to implement the below report in Qlikview....??

gajapathy74 — Thu, 10 Nov 2016 14:45:15 GMT

See the attached QV file

Re: How to implement the below report in Qlikview....??

gajapathy74 — Thu, 10 Nov 2016 14:50:59 GMT

Updated the total count and total amount logic.

Re: How to implement the below report in Qlikview....??

MK9885 — Thu, 10 Nov 2016 14:55:17 GMT

Is this a solution for above question posted by Subbu Jasti?

I'm confused.

Re: How to implement the below report in Qlikview....??

gajapathy74 — Thu, 10 Nov 2016 14:59:18 GMT

yes

Re: How to implement the below report in Qlikview....??

Mon, 14 Nov 2016 12:27:58 GMT

Hi Gajapathy,

I didn't find any attached qv file. If u don't mine could you please share again.

Thanks & Regards,

Subbu

Re: How to implement the below report in Qlikview....??

Mon, 14 Nov 2016 12:35:21 GMT

Hi Arvind654,

I have caclulated the % on Count = I have dimension Remarks,In remarks dimension I have instant,CHQ,DD and Online values.So I have calculated "(Instant count+CHQ count)/Total Count".This is the logic for %.

and

% Amount = (Instant amount+CHQ amount)/Total amount

Thanks & Regards,

Subbu

Re: How to implement the below report in Qlikview....??

Mon, 14 Nov 2016 12:37:10 GMT

Hi Varsha,

I didn't find any solution for the above requirement.That's y I have shared and attached sample data as well.

Thanks & Regards,

Subbu

Re: How to implement the below report in Qlikview....??

saimahasan — Mon, 14 Nov 2016 12:49:05 GMT

Instant, CHQ, DD and online will not be available as Headers as shown in th image by you.rest everything can be done.

Re: How to implement the below report in Qlikview....??

gajapathy74 — Mon, 14 Nov 2016 15:26:30 GMT

Hi,

I have attached the file again. If you still don't see the attachment, share your email ID to send the file.

Regards