Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bharani8
Creator III
Creator III

Chart should be static irrespective of selection

Hi Experts - I have a quick clarification...

In the attached qvw... i have a Calculated Date field (Plz forget the logic in that expression )

Now my requirement is , When i select the date in that Multibox... i dont want any corresponding selection to happen in the chart below .... Strictly plz suggest other than ALTERNATIVE STATE

1 Solution

Accepted Solutions
sunny_talwar

Check attached

Changed the calculated dimension to this

=If((Right(Date(If(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD, YDAY, Month_Name, Year_Name>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4)&

Left(Date(if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD, YDAY, Month_Name, Year_Name>}YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max({<CALENDAR_YEAR_MONTH_CD, YDAY, Month_Name, Year_Name>}YDAY),Month_Name, Year_Name),YDAY))))

View solution in original post

36 Replies
sunny_talwar

You can use Sum({1}Value) and then no selection will impact your chart

sunny_talwar

Or this to ignore selection in just YDAY field

Sum({<YDAY>}Value)

devarasu07
Master II
Master II

Hi,

Try like this (just ignore Date the selection from your chart object using set analysis method)

sum( {<YDAY=>}Value)

Capture.JPG

bharani8
Creator III
Creator III
Author

Hey Sunny - TY!

In this dummy DB it is working fine... but same logic it is not working my original DB ...

In my main DB.. i have a Month field created with below Exp...

=if((right(Date(if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),4) &

     lEFT(Date(if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY),'MM/DD/YYYY'),2)) = CALENDAR_YEAR_MONTH_CD,

MonthName((if(YDAY=Aggr( NODISTINCT Max(YDAY),Month_Name, Year_Name),YDAY))))

and in the chart ,i have 3 expressions... How do i make this chart static.. irrespective of any month selected ??

sunny_talwar

May be you need to ignore selection in YDAY, Month_Name and Year_Name... the best way to know is to make a selection and see what all fields have selection in the current selection box. Ignore selection in all those fields to make it static when you select in the above

vvvvvvizard
Partner - Specialist
Partner - Specialist

Good day

Right click the obkect and choose detach

bharani8
Creator III
Creator III
Author

Yes.. Same thing i followed... I see 4 fields selected in the Current selection box...

So i gave in all the 3 expression as below..

Exp1 -->sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[Financial Plan])

Exp2-->Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[MTD Shipments])

Exp3-->=(Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[MTD Shipments])/Sum({<CALENDAR_YEAR_MONTH_CD = ,YDAY = ,Month_Name = ,Year_Name = >}[Financial Plan]))

Still i see the chart is changing when i select the Month..

CurrentSelection.PNG

bharani8
Creator III
Creator III
Author

But there are few other selections for which i need the chart to change

bharani8
Creator III
Creator III
Author

Any Idea stalwar1‌ ?