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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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