Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hassansm
New Contributor II

By default App data to be shown based on max process month

Hi,

My requirement is to show the app data (KPI, chart, table) by default based on the max process month, but data should be refreshed based on user selection as well.

Process dateActual cost
30-Dec-20171000
01-Feb-20182000
31-Jan-20185000
19-Mar-20186000

Thanks

1 Solution

Accepted Solutions
shiveshsingh
Honored Contributor

Re: By default App data to be shown based on max process month

Hi

Can you try this?

=Sum({<[monthyear] ={"$(=max(date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')))"}>}[Actual cost])

13 Replies
jyothish8807
Honored Contributor II

Re: By default App data to be shown based on max process month

Try this:

Sum({<[Process date]={"$(=max([Process date])"}>}[Actual cost])

Br,

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: By default App data to be shown based on max process month

In this case, if you dont select any month while opening the application, it will take 19 mar 18 as max date and then if you select any other date then that will become max date.

Best Regards,
KC
shiveshsingh
Honored Contributor

Re: By default App data to be shown based on max process month

Put this in your expression,

=Sum({<[Process date] ={"$(=max(date(date#([Process date],'DD-MMM-YYYY'),'DD-MMM-YYYY')))"}>}[Actual cost])

Dimension ---> [Process date]

hassansm
New Contributor II

Re: By default App data to be shown based on max process month

Hi Jyothish,

I have applied your suggestion in KPI object , nothing is shown. Instead of Process date , i am using monthyear field and the format of this filed is "Mar-2018".

Please suggest .

Rgds,

Hassan

hassansm
New Contributor II

Re: By default App data to be shown based on max process month

Hi,

I have applied your suggestion in KPI object , nothing is shown. Instead of Process date , i am using monthyear field and the format of this filed is "Mar-2018".

Please suggest .


Thanks and Regards,

Hassan

shiveshsingh
Honored Contributor

Re: By default App data to be shown based on max process month

Hi

Can you try this?

=Sum({<[monthyear] ={"$(=max(date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')))"}>}[Actual cost])

jyothish8807
Honored Contributor II

Re: By default App data to be shown based on max process month

try this:

=Sum({<$(=date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')) ={"$(=max(date(date#([monthyear],'MMM-YYYY'),'MMM-YYYY')))"}>}[Actual cost])

Br,
KC

Best Regards,
KC
hassansm
New Contributor II

Re: By default App data to be shown based on max process month

Yes, It's working. Thanks for your suggestion.

How to apply this solution in filter pane object, i have monthyear filter field, by default max monthyear to be selected while opening the app.

chinnuchinni
Contributor III

Re: By default App data to be shown based on max process month

you can use the onopen trigger

Community Browser