Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Set Analysts Exclude problem

Hello,

I want to exclude two values, Unfortunately, The pop up coming only exclude values.

Help me Please

=If((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) >=70,RGB(255,0,0),

  if((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) <70 and (Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) >50 ,RGB(0,255,0),

  if((Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])) <=50 ,RGB(255, 165, 0)

  )

  )

)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
11 Replies
Highlighted
Creator II
Creator II

Hi Anil

Are you taking about the pop up values displayed in a chart? If so what version of Qlikview are you using? You can suppress the pop-up values in the charts presentation tab and then create an additional expression that you can display as a custom pop-up. Can you explain a little more what your requirement is please?

Kindest Regards

Brian

Highlighted

Brian,

I am working on Funnel Chart.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator II
Creator II

Anil

The chart type shouldn't matter. Do you have an option to un-tick the pop-up labels on the chart's properties presentation tab? If you un-tick that the automatic pop-ups will disappear and then you can create your own expression to display exactly what you want to show. However the reason for asking which version you have is there was an error in Qlikview 11 sr6 onwards I believe which meant if you un-ticked the pop-up on the presentation tab it would also hide your custom pop-up. However this bug was fixed in sr10. Hope this link may be useful for you.

Re: Custom popup only appear if Popup labels checked

Highlighted

Brian,

I am not asking about Pop-Up.

I have one field, In that i want to exclude two values. I am asking about Set Analysis. I wrote some code on that, I am asking you is that is correct ot Not?

- Anil

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Hi Anil,

Which value are you trying to exclude? Otherwise, have you tried using =- in the set analysis that you are using?

Highlighted
Creator III
Creator III

Hi.

Which two values you want to exclude.??

Thanks

Highlighted

I have table like below

namerepScore
A
AlanYoung
40
B
AllisonMcMurray
130
C
AlanYoung
140
D
AmjadMahmood
40
Sales Objective Category
AlanYoung
60
Key Message Delivery
AmjadMahmood
40

Here, I want to create one funnel chart, With the key of whoever received the highest avg score.

I mean,

1) >70 is one

2) <70 and >50

3) <50

Note: I have taken calc dim -

I created one variable - vAverage = Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score])

Dimension

=Aggr(If($(vAverage) < 50, '<50',

If($(vAverage) > 70, '>70',

'50-70')),[rep])

Expression

vAverage


Expression BG Color

=If(Avg({$<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) >=70,RGB(255,0,0),

  if(Avg({$<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) <70 and Avg({<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) >50 ,RGB(0,255,0),

  if(Avg({$<[2014 name] = {*}-{'Key Message Delivery','Sales Objective Category'}>} [2014 Score]) <=50 ,RGB(255, 165, 0)

  )

  )

)

Now, I want to know is that expression is correct one or not?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Kishore,

I want to exclude these two 'Key Message Delivery','Sales Objective Category'

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

Hi,

the expression looks correct.

I might suggest, since you have a variable already, you can try this:

=If(vAverage >=70,RGB(255,0,0),

       if(vAverage <70 and vAverage >50 ,RGB(0,255,0),

            if(vAverage <=50 ,RGB(255, 165, 0)

            )

       )

     )

Makes a bit more readable