Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Plot frequency of date change

Hi Experts,
I have a table with order number and the order date field. Order date can change for the same order number. The requirement is , I have to check the frequecny of order date change  and plot them . From the sample below,  there are 3 occurances where order date changed twice and once with 4 times. I have to plot , frequency 2 on X-axis  and corressponding freqeuncy 75% on Y-axis and frequncy 1 with 25% on Y . Greatly appreciate your help in achieving this. I have also attached the sample file if you need.
Orderorder date
11111/01/2012
11111/02/2012
11111/03/2012
11111/04/2012
22211/03/2012
22211/09/2012
33311/01/2012
33311/06/2012
44411/10/2012
44411/13/2012
3 Replies
MVP & Luminary
MVP & Luminary

Re: Plot frequency of date change

See attached qvw


talk is cheap, supply exceeds demand
Highlighted
renjithpl
Valued Contributor

Re: Plot frequency of date change

Count(Distinct [order date])

this will give the distinct count of order date.

Not applicable

Re: Plot frequency of date change

Thanks  a ton Renjith , that helped.