Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to create a customized Dashboard in QV?

Hi Everyone,

I am working on requirement to create a customized Dashboard in QV.. which should show the latest activity for last 6 months.

I have a data set worth of 1 year and with daily activity format as below.

Input:

DateCumulative Sales
1-Jan-201410
31-Jan-201440
2-Feb-201455
27-Feb-2014105
3-Mar-2014125
21-Mar-2014165
30-Mar-2014300
Etc.,

Desired Output:

Header EOM-1EOM-2EOM-3EOM-4EOM-5EOM-6
Date30-Mar-201427-Feb-201431-Jan-2014NANANA
Cumulative Sales30010540NANANA

Much appreciate your guidance and help on this!

Thanks,

Prakash

2 Replies
Highlighted

Re: How to create a customized Dashboard in QV?

Have a look at some examples for dashboards and charts you like.

Copy the chart into a new sheet on your app, then adjust the dimensions and expressions to use your fields to get the chart working. Usually get one dimension and one expression correct and the chart will start working with your data.

Highlighted
Master II
Master II

Re: How to create a customized Dashboard in QV?

Hi.

If it's supposed to be static you can calculate it in the script.

Just create a table (Date, Header) using autogenerate(6) and addmonths() function.

Then you can simply use  the Header field as dimension in your desired chart.

Otherwise, you can use calculated dimension in your chart using aggr() based on the Date field with some constraints to keep only 6 desired months.

Anyway you need to choose the current month (EOM-0) somehow.