topic Re: Qlikview need to filter two dates !!! in QlikView

Qlikview need to filter two dates !!!

Thu, 30 Apr 2015 16:03:08 GMT

Hi !

I Have a FACT table with sells, product and a date on it and I have a table with dates that is related with the FACT table.

I have a graph that needs to compare 2 diferents dates, so I create an auxiliar DATE table for filter this seconds dates .

The problems is that sometimes when I select the First date, some products on the fact table are disabled . it is correct , because these product were not sell on the date I chose on the FIRTS DATE, But They were sell on the date of the SECOND DATE, so I need these prodcuts to be ENABLED !!!!

Any IDEA ???

Re: Qlikview need to filter two dates !!!

Anonymous — Thu, 30 Apr 2015 16:07:26 GMT

There are many ways. For example, try using variables for your 1st and 2nd date. You chose a date in a variable, nothing is selected in the DATE field. In expression, use set analysis or if()function to calculate data between the 1st and 2nd.

Re: Qlikview need to filter two dates !!!

Thu, 30 Apr 2015 16:44:20 GMT

I am sorry, but I can not undestand your answear , I need to pick one or a range of dates for a column and another for the second column.

The problem is thar the FIRST DATE filter the hole aplication, so a lot of products can not be selected because there are disabled. Altrought they have sells for the second date.

Can you help me with this??

Re: Qlikview need to filter two dates !!!

Anonymous — Tue, 25 Oct 2016 12:23:18 GMT

Try this:

testeVariasDatas.qvw

Re: Qlikview need to filter two dates !!!

Clever_Anjos — Tue, 25 Oct 2016 12:25:06 GMT

You can use an alternate state to do that

Re: Qlikview need to filter two dates !!!

vinieme12 — Tue, 25 Oct 2016 12:25:26 GMT

Can you provide a sample?

Re: Qlikview need to filter two dates !!!

sunny_talwar — Tue, 25 Oct 2016 12:35:25 GMT

Its a year and a half old discussion guys, I am not sure if the OP is still looking for a solution to this

Re: Qlikview need to filter two dates !!!

Anonymous — Tue, 25 Oct 2016 12:37:36 GMT

You're right.

Re: Qlikview need to filter two dates !!!

sunny_talwar — Tue, 25 Oct 2016 12:40:30 GMT

I guess I understood your intention to post here, but it was more to let vinieme12‌ and cleveranjos‌ that they might not hear back from the OP on this issue

Re: Qlikview need to filter two dates !!!

vinieme12 — Tue, 25 Oct 2016 12:42:01 GMT

Lol, didn't notice Thanks stalwar1‌

Re: Qlikview need to filter two dates !!!

sunny_talwar — Tue, 25 Oct 2016 12:48:23 GMT

That is what friends are there for