Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

chauhans85
Esteemed Contributor

Re: Previous Month

no change required in expression

see below code

first expression

Sum({$<Month={"$(vCurrMonth)"}>}Volume)

second expression

Sum({$<Month={"$(vLastMonth)"}>}Volume)

third expression

=Column(1)-Column(2)

hope this helps

Not applicable

Re: Previous Month

What is monthYear ? Should i make a variable called month year also???

Highlighted
chauhans85
Esteemed Contributor

Re: Previous Month

its a field available in your application.

Not applicable

Re: Previous Month

Hmmm - i dont see it anywhere???

Not applicable

Re: Previous Month

IS it because i only have Personal edition ATM?

chauhans85
Esteemed Contributor

Re: Previous Month

if you have date field in script then make it as

Month(Date)&'-'&Year(Date) as MonthYear

Hope this helps

Not applicable

Re: Previous Month

I dont have any scripts - I made my DATE dimension in the data warehouse (ssis) - i have not created a MasterCalendar.... Do i need to do that?

shree909
Valued Contributor II

Re: Previous Month

so u have only month dimension? dont you have any dimenion related year, date, something like that...

Not applicable

Re: Previous Month

No i have a DateDimension

My Date dimension includes: Days, Month, Years, Quarter, Weeks and so on....

I have a row called Month_Name which includes january,feburary and so on... I try to use that one but it doesnt work?

Not applicable

Re: Previous Month

i cant it to work - i think its something about my timestamps ? Yours are in // - The strange think is when i make vCurrMonth i can see my months when selecting - but i cant see any sum...

If i make a listbox with the date as dimension and sum on my byprice it works perfectly!

Have i forgotten to change something somewhere???

Community Browser