topic Re: How to pick the total value form selected value in QlikView

How to pick the total value form selected value

Karim_Khan — Wed, 02 Sep 2015 15:53:16 GMT

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,

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌@

Re: How to pick the total value form selected value

jonas_rezende — Wed, 02 Sep 2015 20:42:25 GMT

Hi, Karim Khan.

See if the file attached helps.

Hope this helps.

Re: How to pick the total value form selected value

jagan — Thu, 03 Sep 2015 02:47:46 GMT

Hi,

Try like this

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

Regards,

Jagan.

Re: How to pick the total value form selected value

Karim_Khan — Thu, 03 Sep 2015 09:11:12 GMT

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,