Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Data how to achieve a year-on-year show

datesalebrandtype
2012-01-0110Pepsi2L
2012-01-0220Coca-Cola1L
2012-01-0330Pepsi1L
2011-01-0440Coca-Cola2L
2011-01-1250Coca-Cola1L
2011-01-1360Pepsi1L

How do I get a Coca-Cola brand a year-on-year?     and the same 'type' ???

thanks.

Tags (1)
4 Replies
Not applicable

Re: Data how to achieve a year-on-year show

HI,

try with Group By Year and Brand in the load script.

Not applicable

Re: Data how to achieve a year-on-year show

but there are more different grouping field.

Not applicable

Re: Data how to achieve a year-on-year show

Hi,

Create a extra field as year(date) as year and use the required grouping in setanalysis

thanks,

Sampath

Not applicable

Re: Data how to achieve a year-on-year show

Hi, Please find the attached applications and Hope this will help you

Community Browser