Discussion board where members can get started with Qlik Sense.
I have day field which is no. of days from starting onwards in my data like 1,2,3,...
Here to get the no. of weeks divided the day with 7 and by using ceil i got but it displays week even for incomplete weeks how to avoid those
field have 1 to 16
how to avoid 15 and 16 day values
Probably better to set a variable in the load script, see sample data below:
Data2:load * Inline [D12345678910111213141516];
MaxDayTemp:load Max(D) as MaxDayResident Data2;
Let vMaxDay = Peek('MaxDay') - Mod(Peek('MaxDay'),7);Drop Table MaxDayTemp;
Using the variable vMaxDay in Set Analysis
Using the Mod function is Set Analysis
The suppress the zeros in the chart.
View solution in original post
Thanks for your reply
Its working but when we have case like below it showing only for maximum one
load * Inline [Country, D,RevenueIndia,1,200India,2,250India,3,500India,4India,5India,6India,7India,8India,9India,10India,11India,12India,13India,14India,15India,16
From above the above data i would like to build line chart for different line to each country by day and revenue
but your suggested condition working for only maximum days having country