Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try not to post the same question again,
% 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.
See the attached QV file
Updated the total count and total amount logic.
Is this a solution for above question posted by Subbu Jasti?
I'm confused.
yes
Hi Gajapathy,
I didn't find any attached qv file. If u don't mine could you please share again.
Thanks & Regards,
Subbu
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
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