Need help in desgining phase

[#1]

Hi,

I have a data from 2015 and its about the purchases from different market area and regions. Please let me know how to design and how to show the entire data using qlikview.

Ex total by market area,

total by region,

year,

month,

comparisons

% change

[kumarkp412]

Hi Dinesh,

Tell me what help you need from my side.

Thanks

Kumar KVP

[#3]

i have data from 2015 Jan. I want to show YTD of Jan 16 and MTD of Sep16.

i tried set analysis to arrive this. but when i click on some other month/year values are changing

i dont know how to fix it even if i change the filter

[kumarkp412]

Hi Dinesh,

Can you provide ur expression u used.

If possible can you provide sample file on this.

Thanks

Kumar KVP

[#5]

='Total YTD Offering for 2016 : ' & Sum({1<Offer_Year={"(=year(max(Offer_Year)))"}>}Volume)

='Total MTD Offering for 2016 : ' & sum({1<OFFR_DT={"$(=month(max(OFFR_DT)))"}>}Volume)

Let me know if u r free tomm we will discuss it in skype, since i cant add the file here

[kumarkp412]

Hi Dinesh,

In ur expression, u r calculating values for max year. Then it will take

only one single value right.

Instead of that we can use dates from and to till today.

Try this.Put ur date field in place of date.

Sum({<year=, date ={">=$(=num(yearstart(MAX

(date))))<=$(=max(date))"}>}Volume )

let me know if you need any help.

Ya sure I will be avaliable tomorrow.

Thanks

Kumar KVP

[#7]

i used the above experession and it is showing the total starts from 2016-2017

[#8]

I want to show the top 5 regions based on volumes, but for the year or month which i selected.

If all filters are removed, then it should show the current year and month top 5

EX:

if i select 2015, then based on the 2015 volume rank has to be given.If nothing is selected then it should consider 2016

[kumarkp412]

Hi Dinesh,

Sorry for the late reply.

For this scenario,

There is an option to take currently selected value in Qlikview and make a condition as below sample example.

=if (match(GetFieldSelections(FiscalYear),FiscalYear),1,0)

It displays the value 1 or 0 when you selected fiscal year then it equal to a fiscal year(field) then 1 else 0.

In this way you can write a condition , when you selected fiscal year  then equal to date year(field) then take the selected year or else max year.This condition should be written in expression level.

I hope it would be helpful.

Please let me know if you have any queries.

Thanks

Kumar