Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Data from different periods together in one Dashboard

Hi,

I would like to show some data from different periods together in my dashboard.

It is called "Ressource Planning" and should show the actual order status (absolut / YTD) and

how many colleagues are in the logistic (Today).

I want to show the info together without changing the period.

In the moment it looks like in the two screenshot. Either the order status or the staff info is correct.

Has any of you an idea for me?

Thanks in advance.

Oliver

Screenshot at Feb. 13 14-19-11.pngScreenshot at Feb. 13 14-19-41.png

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Data from different periods together in one Dashboard

=sum({$<CAL_Date={"$(=Date(Today(), 'DD.MM.YYYY'))"}>}RP_Jobber_Vormittag)

11 Replies

Re: Data from different periods together in one Dashboard

You will need for this expression with set analysis, like:

sum({< Date = {"$(=today())"}>} value)

sum({< Date = {"$(=today()-365)"}>} value)

Have a look here http://community.qlik.com/search.jspa?q=set+analysis and within the help.

- Marcus

Not applicable

Re: Data from different periods together in one Dashboard

=num(sum({< CAL_Date = {"$(=today()-365)"}>}BEL_Auftrag_Umsatz_Wartend), '#.##0,00') & ' €'

doesn't work (Result 0).

={< CAL_Date ={$(=Date(Today(), 'DD.MM.YYYY'))}>}RP_Jobber_Vormittag

doesn't work - no Info shown

It's a little bit frustrating with this set analysis for me because the editor always says "Expression OK" but underlines everything.

Is there somewhere a good manual with the syntax and examples for today an the last 365 days?

Not applicable

Re: Data from different periods together in one Dashboard

Next try: =sum({$<CAL_Date={"$(=Date(Today), 'DD.MM.YYYY')"}>}RP_Jobber_Vormittag)

Looks good in editor but with no result.

There are many possibilities to make mistakes with this brackets, although you are familiar to code.

mov
Esteemed Contributor III

Re: Data from different periods together in one Dashboard

=sum({$<CAL_Date={"$(=Date(Today(), 'DD.MM.YYYY'))"}>}RP_Jobber_Vormittag)

Not applicable

Re: Data from different periods together in one Dashboard

Thank you Michael,

that helps

Not applicable

Re: Data from different periods together in one Dashboard

Is it possible to show only data (date from an Excel file) without sum/count or something like that?

I tried ={$<CAL_Date={"$(=Date(Today(), 'DD.MM.YYYY'))"}>}RP_Shipout_Datum but it seems not to be the correct way.

mov
Esteemed Contributor III

Re: Data from different periods together in one Dashboard

ou can use set only within a function - in this case try only():

only({your set here} Field)

Not applicable

Re: Data from different periods together in one Dashboard

sorry, but what is the meaning of "your set here"?

Thanks for your patience.

mov
Esteemed Contributor III

Re: Data from different periods together in one Dashboard

whatever your set analysis expression is, for example (copying, in bold):

=only({$<CAL_Date={"$(=Date(Today(), 'DD.MM.YYYY'))"}>} RP_Shipout_Datum)

Community Browser