Dear All,
Please I am new to qliksense I need your answer on the scenario below:
I want to take average year sales of different products and use it as a basis of all the months (meaning that if the product doesn't exist in a month let say Feb but because it exist in another month let say Dec then it should give me the year average for month Feb and also same average across all other months) so in the pivot table I want all the month to have that constant previous year average.
Note : I don't mind doing this in the load script or expression
Thanks so much all in advance