Hello

I did fresh install of Qlik Sense Desktop and create my first app. I add some table in-app manualy and also connect to one data source (Oracle DB). Everything work except Data model viewer. This option is (in left upper menu) still disabled. I can not access it. Any idea?

I do not want to add if else in my expression as we are going through some standards.

Please help me to convert the below expression without If

if(GetSelectedCount([Employee])=1,
avg({<Level={3}, [Department Code]={2}, Country={'India'}>} Target),
if (GetSelectedCount(Department)=1,
avg({<Level={2}, [Department Code]={2}, Country={'India'}>} Target),
avg({<Level={1}, [Department Code]={2}, Country={'India'}>} Target)))

Hi to all,

I'm checking the new Trellis container from the June 2019 Qlik Visualization bundle. I succeeded in basic usage, but I couldn't find any documentation or example about these options of the extension:

• Show all possible values: what does it actually do?
• Advanced mode: I tried the placeholders in Set Analysis in the Master Visualization without success. Anyone could provide some hints or examples on how to actually use them?

Thanks in advance for your time. Best regards.

- Federico Rizzello

I have the following fields: Company, Question, Response, Year.

I am trying to create a gauge that shows the response to a specific question for a specific year.

Here is my equation:
KPI: SUM({$<Question={"Cost"}>}Response)

My min/max bounds are:
Minimum: =MIN({<Question={"Cost"}>}Response)
Maximum: =MAX({<Question={"Cost"}>}Response)

This works fine, but I want to lock my min and max so they don't respond to a filter.  That way I can filter by company and the gauge value will change, but the min and max will not.  However, I still want to filter by year.  I want the 2018YE min value and the 2018YE max value for my min and max. 

I found several methods of attempting this, but none had an equation for the KPI.  I'm sure I'm just messing up my brackets or parentheses somehow, but I can't figure out how to tell my max and min to ignore all filters except the filter on Year. 

Any suggestions would be appreciated.  Thank you!