topic Re: Moving Calculated Dimension to Set Analysis in QlikView

Moving Calculated Dimension to Set Analysis

aetingu12 — Sat, 16 Nov 2024 03:44:44 GMT

All,

I have a calculated dimension as such :

=if(MATURITY_DATE >= MonthStart(SUMMARY_DATE) and MATURITY_DATE <= SUMMARY_DATE,'Matured','')

and a expression as:

sum({$<SUMMARY_DATE = ,UK = {'N'}, FRUIT = {' '}>} PRICE)/-1000000

This gives me what I want which is what portion of my produce has matured. I need to move the calculated dimension in to my expression due to the way I need to report (I have created a list of values with ValueList('Total','Maturites'))

When I move my calculated field on to my expression as:

sum({$<SUMMARY_DATE = ,UK= {'N'}, FRUIT = {' '},MATURITY_DATE = {">=$(SUMMARY_DATE)<$(SUMMARY_DATE)"}>} PRICE)/-1000000

It doesn't seem to give me what I want. Maturity date is in number format, Summary date is in date. I wonder if that is the reason.

Any help is more than appreciated.

Thanks,

Re: Moving Calculated Dimension to Set Analysis

bramkn — Fri, 26 Apr 2019 08:05:53 GMT

if one is a num and one is a date this would cause an issue yes. so its best to change this and see if it works.

Re: Moving Calculated Dimension to Set Analysis

aetingu12 — Fri, 26 Apr 2019 08:07:27 GMT

It is strange that is not an issue within the calculated dimension, but in the set analysis.

Re: Moving Calculated Dimension to Set Analysis

bramkn — Fri, 26 Apr 2019 08:09:07 GMT

Thats true indeed. I make sure to always use nums to be sure it is going to work. Also make sure there is no time with that date. So always use floor.