topic need help in QlikView

need help

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

i have a chart like below

i have taken 2 dimensions with one expression

the user wants only last 3 months data. suppose this month is march , user wants data from january

if the current month is april 2017 , user wants the data form feb 2017 to april 2017

i have given 2 dimensions as and expression as below

can ayone please help

Re: need help

sarvesh — Fri, 17 Mar 2017 08:17:17 GMT

For this you can you use a filter of "Month" by which user can chose month accordingly.

Re: need help

avinashelite — Fri, 17 Mar 2017 08:20:21 GMT

Try like this

define a variable

v3Month

=addmonths(MonthEnd(max(AsOfDate))+1,-3)

vMaxDate

=Date(today())

Count (DISTINCT {<DateField={">=$(v3Month) <=$(=vMaxDate)"}>} Num)

Re: need help

PrashantSangle — Fri, 17 Mar 2017 08:37:51 GMT

write set analysis for it.

for example

sum({<datefield={">=$(=date(Addmonths(max(datefield),-3))<=$(=date(max(dateField)))"}>}Sales)

Note : careful with date formats.

Regards,

Re: need help

mshailaja — Fri, 17 Mar 2017 08:42:17 GMT

I HAVE TEST DATA , i dnt have current month data , i have data only up to sept 2016, for testing purpose how can i proceed,

if i click on calender which is showng form jan 2016 if i clisck on sep2016 on calneder , i have to show the data from july,august, september data

is it possible..

Re: need help

avinashelite — Fri, 17 Mar 2017 08:56:15 GMT

Yes possible change the

vMaxDate

=Date(max(Date_field))

rest remains same

Re: need help

mshailaja — Fri, 17 Mar 2017 09:09:45 GMT

while adding i am geetng this error

Re: need help

avinashelite — Fri, 17 Mar 2017 09:42:04 GMT

Your field name is wrong ..check the field name ..or share the sample app

Re: need help

mshailaja — Fri, 17 Mar 2017 10:21:18 GMT

actually i hve a callender ,if i click on calender Month i have to show the data for thelast 3 months of the calender month

please find the screen shot

here if i am clicking on month i am getting of that current month data only.

i have writtn calculation as

dimensions as Group,and month year and expression as below

Count(DISTINCT{<MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -2), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), 0), 'MMM-YY'))"} >} NUM)

and i am getting like this.

my requirement is if i click on marc in calender i have to show jan2016,feb2016 and marc2016 data. How

Re: need help

PrashantSangle — Fri, 17 Mar 2017 10:42:02 GMT

Hi,

Debug your set analysis

1: create straight table

2: use all dimension which you use in bar chart

3: use above expression which you are mention then apply.

4: move your cursor to expression label check what is set analysis evaluating for your expression.

If possible share screen shot of it

5: check Monthyear field dateformat.

Regards,

Re: need help

avinashelite — Fri, 17 Mar 2017 11:05:56 GMT

As per the screen shot your getting the results what you want na ...if you want the selection on the calendar object add the Month Year to calendar Object ...

if you have a Master Calendar then link month year filed with the calendar filed

Hope you got the answer

Re: need help

mshailaja — Fri, 17 Mar 2017 12:20:31 GMT

You didnt undersatnd wat i said

if i click on month on the claneder i have to show previous 3 months data , but for me if i am not selecting month,it is showing last 3 months data.

if i select April i have to show 3 months data like feb,march ,april data like that, please help me

Re: need help

avinashelite — Fri, 17 Mar 2017 12:36:42 GMT

Hmmm

try like this

if(Getselectedcount(MonthYear )>0,Count(DISTINCT{<MonthYear ,MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -2), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), 0), 'MMM-YY'))"} >} NUM),Count(DISTINCT{<MonthYear ,MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -2), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), 0), 'MMM-YY'))"} >} NUM))

Count(DISTINCT{<MonthYear ,MonthYear ={">=$(=Date(addmonths(Max(MonthYear), -2), 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYear), 0), 'MMM-YY'))"} >} NUM)

Re: need help

mshailaja — Fri, 17 Mar 2017 12:49:26 GMT

not coming , i tried with both expressions

showing like that

Re: need help

avinashelite — Fri, 17 Mar 2017 12:53:07 GMT

why don't you share the app...???