Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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