3 days before reloading date

[#1]

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,

[stephencredmond · Accepted solution]

Try this:

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

or

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]

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,

[#4]

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

BestRegards

Önder ALTINBILEK

[#5]

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

[stephencredmond]

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

[#7]

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,

[stephencredmond]

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

[#9]

Hi Stephen,

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

Best Regards,

[stephencredmond]

OK, change the chart to use this expression instead:

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

Stephen