topic Re: Set analysis in QlikView

Set analysis

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have tried to calculate MTD value with the below expression but it is not working.

Expression: (count({<creation_date {">=$(=(vMstart)))<=$(=vYesterday))"},flag={'Non GUI'}>}distinct order_number))

Thanks..

Anil_Babu_Samineni — Thu, 09 Feb 2017 12:37:40 GMT

May be this?

Count({<creation_date = {">=$(vMstart) <=$(vYesterday)"}, flag = {'Non GUI'}>} DISTINCT order_number)

If not post variables and flag in details

jayanttibhe — Thu, 09 Feb 2017 12:53:22 GMT

In addition to Anil;s response : You would also like to have no impact of another Calender fields in your MTD expression;

Just take care it within the set expression : Year=, Month=, Quarter=, Week=, DateField=,

etc.