Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sofiavaz
Creator II
Creator II

Selections

Hi all.

I have a line chart that shows the service level from the first week of the year to the last complete week. This is the expression:

Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},InternalServReadyLateDisp={"Y"}>}InternalServReadyLateDisp)

/(Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"}>}InternalServReadyLateDisp))

I also have different filter panes in order to make my analysis. Everything is ok, except for some filters that, when actionated, make the chart shown values for entire year (including weeks that have not occurred yet).

 

What can I do more in order to force the chart to display values only until when I want?

 

Do you have any idea what I might be doing wrong?

Thank you!

Sofia Vaz

1 Reply
sunny_talwar

May be adding a equal sign might helps

Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(=vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"},InternalServReadyLateDisp={"Y"}>}InternalServReadyLateDisp)

/(Count({$<MillAlloc={"ATF"},AllocWeekYear={"<=$(=vLastAllocWeek)"}, InternalServPfeYn={"N"},InternalServExternalPi={"N"}>}InternalServReadyLateDisp))