Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with the Month dimension


I am trying to bring the month dimension into an existing App, however when I do my 'Conversion' expression is being affected.

This is the formula I am using for Conversion:

 

Sum({$ <[Fin Period] = {"<=$(VMaxFinPeriod)"} - {"<$(vMinFinPeriod)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Sale])
/
Sum({$ <[Fin Period] = {"<=$(vMaxFinPeriodInterviews)"} - {"<$(vMinFinPeriodIntervies)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Interviews])

This forumla works perfectly when I select on Fin Month in the list box. Does anyone know why when the month dimension is brought in the results change?

Thanks

2 Replies
tresesco
MVP
MVP

Assuming you have another field called Month and want to include that in the expression (set analysis). If you want the selection in that field to be disregarded, you have to put Month=, in the set analysis. If you want the selection to filter data accordingly, there should not be anything such in the set.

Not applicable
Author

Can you upload the sample application.