Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi All,

report.png

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 CountInstant Count +CHQ Count /Total Count
% On AmountInstant Amt +CHQ Amt /Total Amount
InstantSingle dimension Values
CHQ
DD
Online

Please find attached sample data as well.

Thanks & Regards,

Subbu

11 Replies
varshavig12
Specialist
Specialist

Try not to post the same question again,

How to implement the below report in Qlikview??

MK9885
Master II
Master II

% On CountInstant Count +CHQ Count /Total Count
% On AmountInstant Amt +CHQ Amt /Total Amount
InstantSingle 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.

gajapathy74
Creator II
Creator II

See the attached QV file

gajapathy74
Creator II
Creator II

Updated the total count and total amount logic.

MK9885
Master II
Master II

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

I'm confused.

gajapathy74
Creator II
Creator II

yes

Not applicable
Author

Hi Gajapathy,

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

Thanks & Regards,

Subbu

Not applicable
Author

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

Not applicable
Author

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