Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need a dynamic variable

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.

6 Replies
v_iyyappan
Not applicable

Need a dynamic variable

Hi,

     Cau you attach sample a file.

Iyyappan

celambarasan
Not applicable

Need a dynamic variable

Hi,

     Report in the sense Sheets or qvw file?

Celambarasan

Not applicable

Re: Need a dynamic variable

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"

celambarasan
Not applicable

Re: Need a dynamic variable

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

Not applicable

Re: Need a dynamic variable

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.2.png

Not applicable

Re: Need a dynamic variable

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.