Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with the expression

The view i am trying to create is you have a MTD count,

FYI-for both of these the dimesions are User and application name also i am performing this in a pivot table.

MTD utilization count- how many times so far does the user performed a session(count of days) as an example i will asume as today is 21st so out 21 days in this month 10 days the user performed a session(doesnt matter about number of sessions on same day).

Does this expression makes sense for the above condition as i being skeptical about it?

=count({$<Date={">=$(=(MonthStart(Max(Date))))<=$(=(Date(today(01/31/2013)-1)))"},[Session Start]={"*"}>}DISTINCT Day)

MTD actual -how many days is it so far in month(lets just say until today its 20 days and it should be dynamic with the selection between different months and years) ALSO the # days are  including all the days at this point it doesn't matter if its a non businessday we still consider.

What should be my condition to show just the numbers days passed so far in this month(MTD)?

1 Reply
Not applicable