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

[#1]

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

[varshavig12]

Try not to post the same question again,

How to implement the below report in Qlikview??

[MK9885]

% 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.

[gajapathy74]

See the attached QV file

[gajapathy74]

Updated the total count and total amount logic.

[MK9885]

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

I'm confused.

[gajapathy74]

yes

[#8]

Hi Gajapathy,

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

Thanks & Regards,

Subbu

[#9]

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

[#10]

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