Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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