Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Chart based on Today()

Hi All

I want to create the chart which counts the ID based on the following date values Today()-14,Today-30,Today()-90 and YTD. I thought of doing it by passing these days values in the cyclic group. Is it the right way of doing it. I am little confused how to do this. Does any one have sample application which does the same thing? If you can attach it will be helpful for me.

Regards

Attitude

22 Replies
MVP
MVP

Chart based on Today()

Hi,

If I understood correctly you might use set analysis for that:

YTD:

=count({<Date={">=$(=yearstart(today()))"}> ID}

Today-14 till today:

=count({<Date={">=$(=today()-14)"}> ID}

etc.

Use this as expression in a chart (just for comparison of these values, you don't need a dimension).

Is this something you intended?

Stefan

Not applicable

Re: Chart based on Today()

Hi Stefan

Thanks for your response! Still I haven't decided which will be the best way to develop this chart. I want to create the chart which is effective enough for the end user to analysis their data.

If you find free time you can give some suggestion on this.

I am welcoming all your suggestion. Please help me out!

Regards

Attitude

Not applicable

Re: Chart based on Today()

Hi Stefen

Just for your information. There is one small mistake in the expression which you have recommended for me.

YTD:

=count({<Date={">=$(=yearstart(today()))"}>} ID)


Today-14 till today:

=count({<Date={">=$(=today()-14)"}>} ID)


Regards

Attitude

MVP
MVP

Re: Chart based on Today()

Yeah, needs to get my eyes checked!

I wrote the expressions on my way home without checking, sorry for that.

I may also misunderstood your original question, I now think you were asking about the way to present your data, not to calculate them..

You could probably use a cyclic group or container to switch between the different values, but I am not sure if this the best way if you are not really out of real estate.

Maybe I would just show them side by side in a table or bar chart, but the periods for which the values are calculated differ, so you can't really compare them one to another, so I would make it pretty clear, what the difference (i.e. period) is. If these values are known KPIs, showing them all side by side (or in distinct objects, side by side) would be ok, I think.

It could also be valuable if you would compare the distinct values to e.g. last years values.

Do you want to share a sample application?

Regards,

Stefan

Not applicable

Re: Chart based on Today()

Hi Stefen

I think instead of using <= we need to use >=, as we are count based on Today() to Today()-14. What do you say? I am little confused with this expression plese clear my doubt. Hope needs are clear are for you.

YTD:

=count({<Date={"<=$(=yearstart(today()))"}>} ID)


Today-14 till today:

=count({<Date={"<=$(=today()-14)"}>} ID)

etc.


Regards

Attitude

Re: Chart based on Today()

HI,

   You should use the  >= sign.

   Let me explain how it works.

   =count({<Date={">=$(=yearstart(today()))"}>} ID)

   Here you are saying give me count of ID where the date is greater than the current yearstart.

   Same way

   =count({<Date={">=$(=today()-14)"}>} ID)

   Here you are saying give me count of ID where the date is greater than the today() -14.

   So here if today is 15-05-2011 it will give you 01-04-2011

 

    Hope this will help you.

Regards,

Kaushik Solanki

MVP
MVP

Re: Chart based on Today()

I don't think so, or have not understand your requirement:

above expression would translate using yearstart(today()) ---> 2011-01-01

to "count all IDs with Date <= 2011-01-01"

Similar, second expression would translate to "count all IDs with Date <= 2011-07-12

Regards,

Stefan

Re: Chart based on Today()

Hi,

   Let me explain you again.

   =count({<Date={">=$(=today()-14)"}>} ID)

   As i said consider if today is 15-04-2011 then the function today() -14 will give you 01-04-2011

   So accodring to the above expression you will get the count of ID's where the date is Greater than the 01-04-2011.

   So the Id's whos date is lower then 01-04-2011. i.e for example 02-02-2011 will be ignored.

   Now its up to you, that you want to cound the ID's which are greater then ot lesser then the date specified in expression i.e today()- 14.

Regards,

Kaushik Solanki

MVP
MVP

Re: Chart based on Today()

Hi Kaushik,

my post was also related to at titudes question, not to yours, I have seen yours just after posting.

I think our both posts essentially agree.

Regards,

Stefan

Community Browser