is there a slick way to do this in qlik?

[#1]

Hi All, I have data that looks like this:

account	date1	date2	amount
a0001	01/01/2010	05/01/2010	500
a0002	01/02/2010	05/02/2010	650
a0003	01/03/2010	05/03/2010	245
a0004	01/04/2010	05/04/2010	300
a0005	01/05/2010	05/05/2010	350
a0006	01/06/2010	05/06/2010	600
a0007	01/07/2010	05/07/2010	400

I have two charts one based on date1 the other on date2.

What I want to do is show one calendar where the user can select a date.

Then based on that date selection chart1 shows that selection for date1 and chart two shows the report for the same selection but on date2.

I can create a separate calendar with all dates but it's getting date1 and date2 to work from the saperate calendar selection that's making my head hurt!

Many thanks,

Phil

[kaushiknsolanki]

Hi,

   Can you  upload the qvw file.

Regards,

Kaushik Solanki

[#3]

Hi,

See if this can help you.

Cheers.

[#4]

Hi, Many thanks for that, that's a cool solution!

Though that works I'd have to double the size of my data, 750k rows at the moment and theres about 60 dimension fields as well as the financial stuff.

I've attached a simplified example of what I want to do.

Thanks again.

Phil

[#5]

This is a simplified sample of what I'm trying to do.

[#6 · Accepted solution]

Then you can try this way.

[#7]

Thank you sooo much

[#8]

Good it helped you.