Qlik Community

Qlik Sense App Development

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

joeybird
Contributor II

exclude string set and date today set analysis


Hiya

I have a calculation - set analysis  as follows

count({$< Department = {"Furniture"} >}Customer_No)

but my two tables have a string in my data load 

e.g

dataload

'Daily' AS "DateType"  .......Table 1

'Weekly' AS "DateType"  .......Table 2

I need it only to count

count({$< Department = {"Furniture"}, DateType="{Daily"} >}Customer_No)

but I still have to on the filter pane DateType select the  Daily, for the correct number to show

also I need to only include OrderDate Today(),  weirdly in kpi on date shows  1899

please help

1 Solution

Accepted Solutions
MVP
MVP

Re: exclude string set and date today set analysis

Your double quote seems to be out of order:

Try this:

=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)

6 Replies
MVP
MVP

Re: exclude string set and date today set analysis

Your double quote seems to be out of order:

Try this:

=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)

mark6505
Valued Contributor III

Re: exclude string set and date today set analysis

Hi,

Sunny's suggest should point you in the right directions. I might be mis-understanding, but are you using multiple calendars? This can cause issues if not set up correctly, The below document can help if that is the case.

Canonical Date

Mark

joeybird
Contributor II

Re: exclude string set and date today set analysis

this worked brill, but weird reason needed a today (1)

=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(1), 'YourDateFieldFormat'))"}>}Customer_No)

thanx team

Kind Regards

MVP
MVP

Re: exclude string set and date today set analysis

Never really understood the difference between Today() and Today(1) (and even seen Today(2)). But I am glad it finally worked.

joeybird
Contributor II

Re: exclude string set  and date today set analysis

I have guessed .... you think its something to do with time zones? as uk, this works as today (1)

MVP
MVP

Re: exclude string set  and date today set analysis

Could be. May be hic‌ can shed some light on this.