Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
t_hylander
Contributor

Dates as expression in a straight table

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
vinieme12
Esteemed Contributor II

Re: Dates as expression in a straight table

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

View solution in original post

2 Replies
Highlighted
vinieme12
Esteemed Contributor II

Re: Dates as expression in a straight table

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

View solution in original post

Highlighted
t_hylander
Contributor

Re: Dates as expression in a straight table

Yes, pivot-table ofcourse.

Thanks!