How to pick the total value form selected value

[Karim_Khan]

Hi Team,

     I wanted to show the % of visits which is

% of visit=(Selected visist / Total Visist).

As per my understanding the value in xls is getting pick on the basis of Entry Pages.

I have created the Dashboard in which the calculation is working fine as per the xls  till the Graph sheet.But while i am trying to calculate the total visits which are on the basis of entry pages in Total sheet i am unable to apply this logic in qlikview.Please help me out

PFA

Regards,

KK

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌@

[jonas_rezende]

Hi, Karim Khan.

See if the file attached helps.

Hope this helps.

[jagan]

Hi,

Try like this

=Count(visist) / Count({1} visist)

Regards,

Jagan.

[Karim_Khan]

Hi Team,

   As per below expression it is showing the total count and selected count.But in my excel the requirment is like

if I select the Program name then its entry pages get selected automatically for which Count(visist)  is woprking fine.But in my Last sheet(Total) the total visit is coming on the bsis of entry pages.

e.g

If  I only select AEC_Industry and AEC_Infrastructre [Program name] and [Campaign Name] AEC_Infrastructre then 16 entry pages will get associtaed with it and visits will be 483 or 497.

But Total Should be 588 as per my excel calculation which is getting the value on the bais of entry pages only.

Each entry pages have the multiple visits.and entry pages is associated with Programme Name.

I wanted to create the scenario in which if I Select the [Progrmme Name] then it should pick the selected entry pages visit and total visist of that entry pages.

=Count(visist) / Count({1} visist)

Regards,

KK