Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
Showing results for 
Search instead for 
Did you mean: 

Two Dimension Trellis with Advanced Mode

I am struggling with the advanced mode for a trellis with two dimensions. The working original formula to create a single chart would be something like this:

count( distinct {$<week={'Previous Week'},day={'Sun'}>} id))

 I cannot, for the life of me, get any combination of vDim, vDimSet, vDimSetFull, etc. to work. I've also tried without advanced mode and that was unsuccessful as well as the values were not being populated correctly.

For example, the same calculation above would show correctly, but when shown in the non-advanced mode Trellis with the day and week dimensions from the set expression above, and the measure as:

count(distinct id)

the values were grossly incorrect, or not present.

I'd like to avoid making 21 individual charts if possible (one for each DoW, for three Weeks), so any assistance here is welcome. 

Labels (4)
0 Replies