Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

how to Ignore the current selection

Hi,

In below screen, the left chart(Pivot Chart) shows  Dealer ,base model(FA) level Number of days and the right charts shows all the  number of days  greater that 30(Blue)

 

Screen1.PNG

Number of days Expression:

(
sum(total<Year,Month,base_model,Dealer_Deal_Stock>mat_count)
/
alt(
avg({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}
aggr(
Sum({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}billing_count)
,Year,Month,base_model,Dealer_Deal_Stock)
),0)


) *30

I have used same expression in left side charts Dimension to get only those Dealers whose Number of days is >30.

Left chart Dimension:

=aggr(
if(
(
sum(total<Year,Month,base_model,Dealer_Deal_Stock>mat_count)
/
alt(
avg({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}
aggr(
Sum({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}billing_count)
,Year,Month,base_model,Dealer_Deal_Stock)
),0)) *30>30,
Dealer_Deal_Stock),Dealer_Deal_Stock)

 

The requirement is when ever i select something from Dealer_Deal_Stock from left chart ,the selection should not show the impact on right hand side chart .which is not happening ,how to disable only Dealer_Deal_Stock selection 

Capture.PNG

 

Note: Only Deal_Deal_Stock selection should not impact on right side chart the other fields selection should change the chart

 

Thanks 

Labels (1)
2 Replies
kunkumnaveen
Specialist
Specialist
Author

In my scenario is it possible to ignore the selections of a field which has been used in grouping .

 

kunkumnaveen
Specialist
Specialist
Author

Any Suggestion on the requirement plz