Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sunny, i am not able to attach the qvw in our previous blog so i created new one. please find the attachmen
thanks ,
hima
Try this
=RangeSum(Before((count({$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'}>}DISTINCT ITEM)), 0, ColumnNo()))
Try this
=RangeSum(Before((count({$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'}>}DISTINCT ITEM)), 0, ColumnNo()))
Hi Sunny,
amazing
your blogs always helps me a lot.
its absolutely working fine, can i create rolling quarters for this. i mean in Reporting Periods part only??
and one more i need is there are few items which are not been shipped yet its coming under quarter Q how can i avoid that
Can you elaborate on your requirements? May be provided the output you expect to see in QlikView
sorry may be was not clear
i want to avoid the Q quarter in the below data. we are getting that Q value due to null values present in the data. but in the shipped count we should show that
i am unable to share the data so i shared the above screenshot.
Are you using a calculated dimension for the dimension at the top?
no i just created year and quarter on that field if see in my script you will find that
May be use a set analysis to exclude it
{<YearQuarter -= {'Q'}>}
Hi Sunny,
i implemented the same in my expression but it is not working. still the Q is appearing in my data is there any chance to remove that.
What are your dimensions and what expression did you use?