topic I need value mapped with a particular date in QlikView

I need value mapped with a particular date

saumyashah90 — Fri, 27 Jun 2014 08:47:08 GMT

Hi Guyz i have a table:

What i need is.

I have a Date Separately called (23/06/2014)

These dates will keep on changing every day or week.So i need their hours to be displayed accordingly

And these Dates you can take as text values generated by some expression.

I used Substringcount

If(SubStringCount(Date#(Dt,'DD/MM/YYYY'),WeekStart(Today()))>0,Hours)
Also tried WildMatch but didnt succeed.

Re: I need value mapped with a particular date

SunilChauhan — Fri, 27 Jun 2014 08:53:03 GMT

take pivot table

in dimension-> date

and expression hours or sum(hours)

and drag date to horizontal

hope this helps

Re: I need value mapped with a particular date

saumyashah90 — Fri, 27 Jun 2014 08:56:11 GMT

Thanks for the reply

1)Yeah i tried making pivot table

But it didnt show up.I mean table was not formed.

2) I need data for a current week that is from Monday to Thursday to be displayed only

Re: I need value mapped with a particular date

MK_QSL — Fri, 27 Jun 2014 08:57:01 GMT

Provide sample data file.. You can achieve this by Mapping Load or Lookup function

Re: I need value mapped with a particular date

Fri, 27 Jun 2014 08:58:53 GMT

Hi,

Can u attach a sample source file ?

And, also clarify if you want the table to be horizontally alligned with the Total of the hours.

Regards.

Re: I need value mapped with a particular date

saumyashah90 — Fri, 27 Jun 2014 09:29:13 GMT

Yeah Manish i need that only but on UI side.

Re: I need value mapped with a particular date

saumyashah90 — Fri, 27 Jun 2014 09:34:56 GMT

Hi Priyanka,

1)Table you can see is the data.

2)And the dates you can see in the text box are the text.

So i need to get hours if that text value and the value in Dt matches.

Hope you understand this.

and yeah total is not the problem

Re: Re: I need value mapped with a particular date

Fri, 27 Jun 2014 09:53:47 GMT

Hi,

Please find the attached file.

Hope it helps !

Regards.

Re: I need value mapped with a particular date

SunilChauhan — Fri, 27 Jun 2014 09:59:48 GMT

use tables as mapping table

Date:

mapping

Load

Date, Hour

from path

use date in different blue buttons

and use

applymap('Date',1) below first date

applymap('Date',2) below second date

applymap('Date',3) below third date

applymap('Date',4) below fourth date

-----

---- till

applymap('Date',8) below eirth date

hope this helps

Re: Re: I need value mapped with a particular date

bariyb23 — Fri, 27 Jun 2014 10:22:36 GMT

Hope this will help you....

Thanks,

Yogesh Bari

Re: I need value mapped with a particular date

saumyashah90 — Mon, 30 Jun 2014 07:02:33 GMT

Hi Priyanka,

I am already able to get this in pivot table.

Request you to limit these dates for only one week (current week).

Week dates should change in next week

Re: I need value mapped with a particular date

saumyashah90 — Mon, 30 Jun 2014 07:56:11 GMT

Not Working

Re: I need value mapped with a particular date

saumyashah90 — Mon, 30 Jun 2014 07:56:53 GMT

Hi Yogesh,

This solutions looks feasible but not working on mine.. might be the table i have used is crosstable

Re: I need value mapped with a particular date

bariyb23 — Mon, 30 Jun 2014 08:40:05 GMT

Can you share sample application

Re: Re: I need value mapped with a particular date

Mon, 30 Jun 2014 09:07:47 GMT

Hi Saumya,

You can use Week() function to compare and fetch the result.

I have modified the Date List, Here I have 30/06/2014 and 31/06/2014 as the values in the list.

Now, since today is 30/06/2014, hence the chart is showing the present Week's data ie. 30/06/2014 and 31/06/2014.

I have attached the sample file for you assistance.

Hope it helps !

Regards.

Re: I need value mapped with a particular date

PradeepReddy — Mon, 30 Jun 2014 09:43:46 GMT

See the attachment... it might be help full for you..

If you select the date from list box,it produces the data for all the 5 days(Monday-Friday) & total..

By default it takes the Latest week data.

Regards,

Pradeep

Re: I need value mapped with a particular date

saumyashah90 — Tue, 01 Jul 2014 13:21:04 GMT

Thats what i dont want...i need not do any selection and it should display data for current week.

Re: I need value mapped with a particular date

PradeepReddy — Tue, 01 Jul 2014 13:23:01 GMT

if you don't select any date.. , it will show the default data for the current week..

Re: Re: I need value mapped with a particular date

PradeepReddy — Tue, 01 Jul 2014 13:29:00 GMT

Please check the attached file..

by default it shows the current week data...

Re: I need value mapped with a particular date

saumyashah90 — Tue, 01 Jul 2014 13:36:50 GMT

It shows data from 23rd.

Right now current week going on should be from 30/6/2014