Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw


talk is cheap, supply exceeds demand
renjithpl
Specialist
Specialist

Count(Distinct [order date])

this will give the distinct count of order date.

Not applicable
Author

Thanks  a ton Renjith , that helped.