Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Re: QlikView app development

yes ..you are right friend

Highlighted
Specialist
Specialist

Re: QlikView app development

Then it looks like Dave Lau had you pointed in the right direction. As he asked, you should also try to get the data file in a better format. Merged cells/rows are no fun.

For each chart dimension use Date(Date,'MMM-YYYY') to get the format you displayed a la "Mar-2017", et al.

Each chart should have 3 expressions:

     Min(Healthy)

     Avg(Healthy)

     Max(Healthy)

     Min(Challenge)

     Avg(Challenge)

     Max(Challenge)

     Min(Danger)

     Avg(Danger)

     Max(Danger)

     Min(Trending)

     Avg(Trending)

     Max(Trending)