topic Re: Data not showing based on selections in QlikView

Data not showing based on selections

Mon, 07 Oct 2013 13:47:02 GMT

Hi,

I have one qvw file. when I am selecting dates the data is not getting based on selections. Coul d anyone let me know why it is not getting as expected.

Thanks.

Re: Data not showing based on selections

salto — Mon, 07 Oct 2013 13:50:36 GMT

Hello Amelia,

have you linked the dates to the "Transactions" table you want to filter on?

Maybe if you upload the document we could have a look at it and check the reason of this behaviour.

Regards,

Re: Data not showing based on selections

Mon, 07 Oct 2013 13:58:51 GMT

Hi,

Check the joining between the tables or post your sample application

Re: Data not showing based on selections

bbi_mba_76 — Mon, 07 Oct 2013 14:02:29 GMT

Hi, in your data field there is also the time ?

Re: Data not showing based on selections

Mon, 07 Oct 2013 14:04:08 GMT

Hi Amelia,

Check your date format once

Re: Data not showing based on selections

MayilVahanan — Mon, 07 Oct 2013 14:04:30 GMT

There is two possibilities:

1. There is no link between the selections field and the expected field.

2. If you use alternate state, then there is no changes in it.

Re: Data not showing based on selections

Mon, 07 Oct 2013 14:24:19 GMT

Hi,

I used the link for Transactions and if I checked the Date it is showing values as Integer format.

Please help me

Re: Data not showing based on selections

salto — Mon, 07 Oct 2013 14:33:19 GMT

Hello Amelia,

I would suggest you to change the date format from integer to DD/MM/YYYY in the load script:

date("Date",'YYYY/MM/DD') as DateID

Use that same field to make the selections.

Would you be so kind to upload the document?

Thanks!

Re: Data not showing based on selections

Mon, 07 Oct 2013 15:16:23 GMT

Hi,

I have two tables one is Company and other is Transactions.

Company contains Dates upto 2013/09/29

Transactions containd Dates upto 2013/10/01

Could you let me now which table do I need to use to create MasterCalendar

Re: Data not showing based on selections

salto — Mon, 07 Oct 2013 15:25:25 GMT

Hi,

If you need to filter dates on both tables (Transactions and Company), concatenate them so you have a single table.

Then create the maste calendar, with a Date field that also exists in the table that results of the concatenation of Company and Transactions.

Should you need help creating a Master Calendar please check http://community.qlik.com/thread/30642, or

http://community.qlik.com/thread/91283

Regards.