topic Re: threshold by various dimension in QlikView

threshold by various dimension

userid128223 — Tue, 18 Jun 2013 16:28:43 GMT

Attached is the QVW for threshold problem i am currently facing.

I have:

User

date

Usage

I have create 3 input fields where user can provide threshold for Year, Month, day threshold.

I want to create a

Pivot table => that shows 3 columns. total usage by year, by month, by day. Color of the total will be either red or green based on their above input threshold.

Chart => that shows the same thing pivot table shows.

Re: threshold by various dimension

Gysbert_Wassenaar — Tue, 18 Jun 2013 16:43:49 GMT

See attached example.

Re: threshold by various dimension

userid128223 — Tue, 18 Jun 2013 17:25:40 GMT

amazing thanks. How can you show chart with same value in green & red based on selection and non selection.

Re: threshold by various dimension

Tue, 18 Jun 2013 20:01:15 GMT

Using Gysbert's example add another "

if(GetSelectedCount(day)=0 and GetSelectedCount(month)=0 and GetSelectedCount(year)=0,if(sum(usage)>vdailythreshold,green(),red())

Note that the day, month, year now have "= 0". You will have to determine what criterial makes the bars green or red like in the orginal expression with the variable.

hth,

Stephen

Re: threshold by various dimension

userid128223 — Tue, 18 Jun 2013 20:17:11 GMT

Thanks I figured that one out.

Now if I had to show only those records that exceeds certain criteria. for example show records where monthly acceds certain number.

Re: threshold by various dimension

userid128223 — Tue, 18 Jun 2013 21:43:20 GMT

Your solution works as long as only 1 year, 1 month or 1 day is selected. Once user selected multiple months or days then the filters dont work.