topic 3 days before reloading date in QlikView

3 days before reloading date

Thu, 25 Feb 2010 14:32:13 GMT

Dear Friends,

I have a chart in the attached file. I would like to limit the graphic with below statement:

the difference between reload date and the TARIHCQDBNEW date field is bigger then 5 days

How can I do that on this file?

Hope to hear you soon.

Best Regard,

3 days before reloading date

stephencredmond — Thu, 25 Feb 2010 14:43:44 GMT

Try this:

Count ({1<NEWSTATE={'User_Test'}, TARIHCQDBNEW={"<=$(=Date(ReloadTime()-5))"}>}NEWID2)

Count ({1<NEWSTATE={'User_Test'}, TARIHCQDBNEW={"<=$(=Date(Floor(ReloadTime())-5))"}>}NEWID2)

The Floor() will remove the time part of the Reload Time - depends on what you need.

Regards,

Stephen

3 days before reloading date

Fri, 26 Feb 2010 15:22:02 GMT

Hi Stephen,

Thanks for your support. I have another question on the same sample. When I press the bar on the chart. I would like to see the ID numbers on a different table. I couldn't achieve this even I create the table. The table doesn't limit the selection. Is this related with the set analysis formula.

Hope to hear you soon.

Best Regards,

3 days before reloading date

Fri, 26 Feb 2010 15:45:13 GMT

Because you are setting records on you exp. to see what you expect...

BestRegards

Önder ALTINBILEK

3 days before reloading date

Fri, 26 Feb 2010 16:03:21 GMT

Hi Onder, Would you please more specific about your suggestion? Best Regards,

3 days before reloading date

stephencredmond — Fri, 26 Feb 2010 18:26:35 GMT

Hi Asim,

Because you are using the {1} set in your chart expression, making a selection on the chart will not look like it is working in that chart, however the list of values in NEWID2 will change (I can see it in the upper-right chart).

The values in ID2 will not change because the data are not connected together. You could create a chart, say a straight table, of ID2 with an expression of, say, Count({<ID2 = P({$} NEWID2)>} ID2) - which would be a referentail set linking ID2 to the values currently selected in NEWID2. (See attached)

See my Blog on the subject: http://qliktips.blogspot.com/2009/09/using-sets-to-avoid-key-tables.html

Stephen

3 days before reloading date

Sat, 27 Feb 2010 08:42:32 GMT

Hi Stephen,

The new chart that you create in your attached file has no data. Did you try it?

Would you please check again?

Hope to hear you soon.

Best Regards,

3 days before reloading date

stephencredmond — Sat, 27 Feb 2010 12:23:06 GMT

Hi Asim,

How do you think I might have created the chart without actually trying it?

This chart uses an Implicit set - unless you are using version 9 then you won't see it.

I am using v9 SR3 - what are you using?

Regards,

Stephen

3 days before reloading date

Sat, 27 Feb 2010 12:31:37 GMT

Hi Stephen,

That's the reason of my problem. I have 8.5 version. Thanks for your great support.

Best Regards,

3 days before reloading date

stephencredmond — Sat, 27 Feb 2010 15:02:44 GMT

OK, change the chart to use this expression instead:

Count({<ID2 = {$(=Concat(NEWID2,','))}>} ID2)

Stephen

3 days before reloading date

Mon, 01 Mar 2010 14:55:19 GMT

Hi Stephen,

Thanks for your solutions. My last question is about the linking IDs to a website. The ID2 fields come from IBM Clear Quest software. What I want to do is directing the user to the CQ web interface to reach the details of the demand when the user click on the related ID. Is this possible?

Best Regards,