Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with denominator within set analysis

I have a line graph with two cyclic filters; the x axis being time periods cyclic filter and the y axis being business fields cyclic filter.

I have to plot the counts per month as  a % of  the current counts for the business fields chosen within the cyclic filter.

I am trying to use set analysis and I am restricting the denominator to the latest month.

 

=

sum({<[%Data Key]={'Market'},
$(=concat({1<$Field-={'Field1','Field2'}>} '[' & $Field & ']=',','))
>}

[%Volume])
/
sum({<

[%Data Key]={'Market'},

[%Date Order]={

$(=max([%Date Order]))},

$(=concat({1<$Field-={'Field1','Field2','%Date Order'}>} '[' & $Field & ']=',','))>}

[%Volume])

However my graph is then only displaying the current month.

Any help would be appreciated.

Thanks


0 Replies