Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor

Set Analysis and problem dates

Edit by community team member:

Post translated by google translate.

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



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.

1 Reply

Re: Set Analysis and problem dates

Why don’t my dates work?

Get the Dates Right

Dates in Set Analysis

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

Community Browser