topic Using Set Analysis to Filter a Histogram by Date in App Development

Using Set Analysis to Filter a Histogram by Date

lankmachine — Wed, 08 May 2024 20:53:13 GMT

Hello,

I'm trying to create a histogram from my data that selects for only the current date.

Currently, I have this as my "Field":

={<[DATE_FIELD] = {"$(=Date(Today(), 'M/D/YYYY'))"}>} [VALUE_FIELD]

But this isn't filtering out the other dates. Is there another approach I should be taking?

Thanks in advance!

Re: Using Set Analysis to Filter a Histogram by Date

hic — Thu, 09 May 2024 08:35:49 GMT

You must use an aggregation function somewhere. Otherwise the set analysis won't work.

For example, you can use this as measure:
={<DATE = {"$(=Date(Today(), 'M/D/YYYY'))"}>} Sum(VALUE)

And you can use this as dimension:

=Aggr({<DATE = {"$(=Date(Today(), 'M/D/YYYY'))"}>} Only(DATE),DATE)

Further, if you have the correct DateFormat in the script, e.g.
SET DateFormat='M/D/YYYY';

then you don't need the formatting function in your set expression. Today() returns the correct format, so you can use
={<DATE = {"$(=Today())"}>} Sum(VALUE)

Re: Using Set Analysis to Filter a Histogram by Date

lankmachine — Thu, 09 May 2024 16:44:42 GMT

For the histogram, I'm not seeing any dimensions or measures that I can change. There are only fields, which I can add several to.

Re: Using Set Analysis to Filter a Histogram by Date

kavicsgym — Thu, 07 Nov 2024 12:56:23 GMT

Hi HIC,

Acc to Qlik Help: "There are some limitations to the dimension used in a histogram.

The dimension must be a numerical field.
You cannot use a master dimension that was created using the expression editor, even if the resulting field is numeric.
The dimension cannot be based on an aggregation function."

My Calc Dim is: =Num(Aggr(Only({<XY_FLAG={'Y'}>}SCORE),SCORE))
It does not work. SCORE is Numeric Intiger field.