comparison with QV

yahiaoui — Wed, 02 Mar 2016 10:06:25 GMT

Hi all, I want to do a comparison with QlikView which allows me when I shoose for exemple a Month , in the Barchart I get 2 bars the first ine is for the month that I selected and the selcond one for the previous month.
For exemple if I shoose June, I get tow bars , one for June and one for May.
Thanks

Re: comparison with QV

swuehl — Wed, 02 Mar 2016 18:10:52 GMT

You can do this using set analysis, something like this:

Create a sequential month number field in the script (assuming your Month field is a dual value with numeric representation)

Data Types in QlikView

LOAD

Sales,

Month,

Year,

Year*12+Month as MonthNo

FROM ....;

first expression:

=Sum(Sales)

second expression:

=Sum({<MonthNo = {$(=Max(MonthNo)-1)}, Month=, Year=>} Sales)

topic comparison with QV in QlikView

comparison with QV

Re: comparison with QV