Set Analysis and problem dates

eugenibaque — Sat, 14 Nov 2015 09:06:18 GMT

Edit by community team member:

Post translated by google translate.

Please post in English unless in a specific language section. Thank you.

---

Hello,

I have a tablet loaded Excel in which there is a date. The charge as it is to QLIK without Date or Date #. In the same table is the Amount field.

I have a vHoy variable, defined as Round (Today ()) in QLIK.

I want to add the amounts vHoy dated before.

SET ANALYSIS use because I need more data later restrict, why not use SUM IF.

My expression is sum ({<Date. = {"<$ (VHoy)"}>} amount) can not be simpler.

It always gives me 0.

I worked so far changed Excel. In Excel if I sack Date format Date and let in General, the cell contains a number, which is not a text.

Dons anyone know I'm wrong?

Thank you.

Re: Set Analysis and problem dates

swuehl — Sat, 14 Nov 2015 11:25:34 GMT

Use steps like described in above blog posts:

1) Examine how your dates are loaded into QV (pure text, dual value, pure number?)

2) Create QV dates (dual values) using Date() / Date#() functions

3) Use formatting functions in set modifier