topic urgent requirement in QlikView

urgent requirement

Anonymous — Fri, 09 Feb 2018 12:41:43 GMT

what I want is a dynamic variable to compare previous month to 12 months data,

and also if I make any selections in the list box so my text objects shud be updated,

current month:user selection

how to do that

Re: urgent requirement

Anil_Babu_Samineni — Fri, 09 Feb 2018 13:56:05 GMT

That is how default Variable can do? What is the issue you are facing?

Re: urgent requirement

Anonymous — Fri, 09 Feb 2018 14:03:21 GMT

how to create that variable

Re: urgent requirement

Anil_Babu_Samineni — Fri, 09 Feb 2018 14:06:51 GMT

Perhaps this?

LET Var = Sum({<Month = {">=$(=AddMonths(Max(Month),-1))<=$(=AddMonths(Max(Month),12))"}>} Sales)

Re: urgent requirement

Anonymous — Mon, 12 Feb 2018 06:45:07 GMT

it shud be treated as a ratio:

like current data view(with latest date data):user selection

I have a datefield in format dd/mm/yyyy

Re: urgent requirement

Anonymous — Mon, 12 Feb 2018 07:10:16 GMT

kindly help as its a urgent requirement .

Re: urgent requirement

Anonymous — Mon, 12 Feb 2018 07:12:38 GMT

count({<datefield={'$(variable1)'},field2-={'value'}>}distinct id)

variable1=addmonths(datefield,-12)

why its not wrking.

Re: urgent requirement

Anonymous — Mon, 12 Feb 2018 08:48:15 GMT

it shub be last year data -current one

suppose the current is 1stfeb2018

1stfeb2018-1stfeb2017

how to create this type of variable

Re: urgent requirement

Anonymous — Mon, 19 Feb 2018 07:49:16 GMT

thanks anil,

my requirement is by default the view shud be of last year ,

but if a user made any selection,so this shud change accordingly,

basically I have done like below

count({<date={'$(vriable1)'}>}distinct field)
-
count({<date={'$(vriable2)'}+ {'$(variable3)'} >}distinct field)

here variable1:captures my max date

variable2:last year date

variable3:user selected date from list box

but its just giving me frst output

in case of second the difrnce is not correct ,I thought of putting OR condition with a + sign ,its not wrking as desired?

Re: urgent requirement

Anil_Babu_Samineni — Mon, 19 Feb 2018 13:03:12 GMT

I know where you made mistake, Will you able to provide application. Perhaps this?

count({<date={'$(variable2)'}>+ <{'$(variable3)'} >}distinct field)

Re: urgent requirement

Anonymous — Tue, 20 Feb 2018 06:41:51 GMT

this is not working :

it also has one more OR Condition:

count({<field1={'value'},date={'$(vriable1)'}>}distinct field)
-
count({<field1={'value'},date={'$(vriable2)'}+ {'$(variable3)'} >}distinct field)