topic Dates as expression in a straight table in QlikView

Dates as expression in a straight table

t_hylander — Mon, 23 Oct 2017 09:28:12 GMT

Hi,

Is there a way to make a table look like this;

I want the dates to be added dynamically depending on what period I have selected. The above is made with set-analysis

sum({1<%SamplingDate={'2017-03-14'}>} Resultat)

Think Ive seen it before but couldnt find it when I searched.

Regards

Tomas

vinieme12 — Mon, 23 Oct 2017 09:49:04 GMT

use a Pivot table instead

with Analys and SamplingDate as dimensions and then drag and drop SamplingDate field to the column headers over the expression

t_hylander — Mon, 23 Oct 2017 09:55:19 GMT

Yes, pivot-table ofcourse.

Thanks!