topic Re: Show current week data in straight table in QlikView

Show current week data in straight table

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi gurus,

I have created straight table with the following data.By default, I need to show current week data only in straight table if user select any date value it will show the data for respective date in the straight table. Is there any other way to achieve it?.

please find the screenshot for your reference.

Re: Show current week data in straight table

sunny_talwar — Fri, 16 Feb 2018 11:59:05 GMT

Do you mean Current Day or Current Week? May be this

If(GetSelectedCount(Timestamp) = 0, Sum({<Timestamp = {"$(=Date(Today(), 'M/D/YYYY'))"}>}Measure), Sum(Measure))

Re: Show current week data in straight table

dapostolopoylos — Fri, 16 Feb 2018 12:00:28 GMT

If i get straight, all you have to do is create a straight table with Metercode as Dimension an Max(Timestamp) as Expression...

You may have to use MaxString(Timestamp) alternatively depending on the data type of the Timestamp column...

Re: Show current week data in straight table

praveenkumar_s — Fri, 16 Feb 2018 12:01:00 GMT

Hi,

Its current day.

Where i need to use this expression. in dimension or Expression in straight table?

Re: Show current week data in straight table

rubenmarin — Fri, 16 Feb 2018 12:02:02 GMT

Hi praveen, maybe with set analysis using max(dateselected) as reference:

Only({<Timestamp={">=$(=WeekStart(max(dateselected)))<=$(=WeekEnd(max(dateselected)))"}>} Timestamp)

Re: Show current week data in straight table

sunny_talwar — Fri, 16 Feb 2018 12:02:39 GMT

Expression

Re: Show current week data in straight table

praveenkumar_s — Fri, 16 Feb 2018 12:03:38 GMT

yes. exactly what i want. thank you very much.

Re: Show current week data in straight table

dapostolopoylos — Mon, 26 Feb 2018 11:56:08 GMT

I'm glad i was able to help...