topic Need a dynamic variable in QlikView

Need a dynamic variable

Mon, 27 Feb 2012 05:34:36 GMT

I need a vairiable to assign the below scenario

To find out number of reports accessed in a month.... For example: some reports may be accessed for 2 or 3 or 6 months and some many not be accessed for any month.... So variable should be dynamic.

Need a dynamic variable

v_iyyappan — Mon, 27 Feb 2012 05:42:15 GMT

Hi,

Cau you attach sample a file.

Iyyappan

Need a dynamic variable

CELAMBARASAN — Mon, 27 Feb 2012 05:43:45 GMT

Hi,

Report in the sense Sheets or qvw file?

Celambarasan

Re: Need a dynamic variable

Mon, 27 Feb 2012 06:04:06 GMT

Attached the sample one.

Two list box will holds the document name and Month end date... It has only limited data. When u select a document name, some month will be selected.

I need a dynamic variable which sould contain the number of months when a doc is selected. I shoul add the variable formula in "Average Visits per User, per Month"

Re: Need a dynamic variable

CELAMBARASAN — Mon, 27 Feb 2012 06:35:13 GMT

Hi,

Unfortunately i cann't open your file because i'm using personal edition please can you explain me in text format or in pictorial.

Celambarasan

Re: Need a dynamic variable

Mon, 27 Feb 2012 06:46:39 GMT

Example to find Unique Users=(Count(Distinct(if(Year([MONTH_END_DT])=Year([MaxDateVar]) and Month([MONTH_END_DT])=Month([MaxDateVar]),[User_Pin_Key],0)))) .......

I need formula to find the Average Visits per User, per Month=(# of visits / Unique Users actually accessing QV) / (# of months)

im having formula for =(# of visits / Unique Users actually accessing QV i need for (# of months) , where # of months is document accessed in a particular month. I have attached the document name and month date. I need a variable for it.

Re: Need a dynamic variable

Mon, 27 Feb 2012 06:53:17 GMT

Hi,

You can have variable defined as

vMonths=Month(Max(Month_End_DT))-Month(Min(Month_End_DT))+1

This should give you count of months.