topic straight table with different date columns in QlikView

straight table with different date columns

MarkusG — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

i have to solve a Problem with an straight table.

I Need a table without dimensions but in different time lines.

All KPI´s i like to Show are calculated and they Need to compared to different times like the Excel example attached.

Thank you and best regards

Markus

vinod22kv — Tue, 25 Feb 2020 10:20:57 GMT

Hi,

By using valuelist and column function we can solve this please check.

Thanks and Regards,

Vinod.

MarkusG — Tue, 25 Feb 2020 14:10:19 GMT

Hi Vinod,

thank you for your quick answer.

It worked so far that i was able to create my columns as needed and YTD is running correct.

But i struggle now by creating variables for yesterday and Prior year.

in the scrennshot just the first line has the correct Formula for calculation ...

i did it like this:

in scrip:

variable manager:

expression:

Thank you

Markus