topic Calculate only one figure in QlikView

Calculate only one figure

Tue, 18 Mar 2014 10:37:13 GMT

Hi,

I have made a diagram (see below). Now I want to calculate (column3) with a formula like column(1) divided through the only one figure (here 1.759). I need this to see the login usage from the users which have registrated their product in January 2013.

When I filter February 2014 I want to see the calculation for this figure and so one.

Hope someone could help!

Best regards,

Armin

Re: Calculate only one figure

alexandros17 — Tue, 18 Mar 2014 10:46:00 GMT

suppose column 1 is sum(field1) and column(2) is sum(fiels2) then

column3 is: sum(field1) / sum({$ <KAL.Jahr={'2013-Jan'}>} field2)

Re: Calculate only one figure

kristof_j — Tue, 18 Mar 2014 10:46:21 GMT

What if you put this formula in your last column

sum(# logins)/ count( distinct {<KAL.Jahr={'2013-Jan'}>} TOTAL users)

Re: Calculate only one figure

its_anandrjs — Tue, 18 Mar 2014 10:48:52 GMT

Hi,

Write some thing like for your field

if(KAL.Jahr = '2013-Jan', Column(1)/ 1.759,0)

Thanks & Regards

Re: Calculate only one figure

Tue, 18 Mar 2014 12:38:23 GMT

Thans for your answers ... but perhaps I have described my problem wrong.

In my app I chose e.g. Jan 2013 and see 3.611 Regs. (Table 1)

In Table 2 I want to see the login development of these 3.611 Regs with the formula

count (DISTINCT{$1<JAL.login_success={">=1"}
, ASP_DIMENSIONS.ESTAT_USER.CAMSID=P({$<ESTAT_REG.ZZ_COUNT_REG={1}>} ASP_DIMENSIONS.ESTAT_USER.CAMSID)>}
ASP_DIMENSIONS.ESTAT_USER.CAMSID)

Table 1

Table 2

When I chose February 2013 table 2 seems empty: