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

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 246,886 members
  • 4,219 online
  • 2,029,747 posts
  • 152,782 Solutions
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Total of aggregated master measure

    I have the following master measure, called "Price-effect"sum(aggr([Preis Δ] * [Menge (V1)] , Item, Werk))As you can see, Preis Δ and Menge (V1) are b... Show More

    I have the following master measure, called "Price-effect"

    sum(aggr([Preis Δ] * [Menge (V1)] , Item, Werk))

    NoahF_0-1743114650726.png

    As you can see, Preis Δ and Menge (V1) are both master measures themselves which include aggregations and other master measures (which also include aggregations and other master measures...).

    Now I am wondering if I can get my total sum of this master measure "Price-effect", excluding my selections (except for the field "Month"). 
    I have tried using Total and {1} but both do not seem to work. 
    I suppose the aggregations of the various nested master measures included in [Preis Δ] and [Menge (V1)] are not affected by my set analysis or total.

    Is there any way to solve this problem?

    Show Less
  • forum

    App Development

    Obsolete CSS modifications

    Here's a list of CSS modifications that used to be common, but no longer are necessary as there are styling settings and other functions that are easi... Show More

    Here's a list of CSS modifications that used to be common, but no longer are necessary as there are styling settings and other functions that are easier to use and maintain.

    CSS Modification Area How to do instead
    Add sheet background color and image. Sheet Use the sheet styling property.
    Remove the sheet title. Sheet Use the app UI settings.
    Remove the toolbar. Sheet Use the app UI settings.
    Hide the buttons in the pivot table. Pivot Use the new pivot table.
    Change the null color in the table. Table Use the null value styling settings in the new tables.
    Pajama stripes in the table Table Use the zebra stripe styling setting in the new table.
    Chart background color and image Chart Use the chart styling settings.
    Chart border and shadow, color, radius and size. Chart Use the chart styling settings.
    Change font family, weight, color and size. Chart Use the chart styling settings.
    Change selection bar colors. App Use theme styling properties.
    Hide popup buttons. Chart Turn off in app settings or per chart in chart settings.
    Modify the context menu. App Customize in app UI settings.
    Highlight rows on hover in table. Table Use styling settings in the new table.
    Hide table header. Table Use styling setting in the new table.
    Color the filter. Filter pane Use styling settings in the filter pane.
    Hide buttons and options in the top bar. App Use the app UI settings.
    Group charts together. Chart Use the Layout container.
    Modify the sheet selector. App Use the Navigation menu object.
    Change the sheet grid. Sheet Use sheet properties or the Layout container.
    Remove the search icon in the table. Table Use the new tables.
    Show Less
  • forum

    App Development

    URL as image in a straight table not working

    Hi,   I'm trying to display images in a table without having to use extensions. The table object clearly has some related options, but it doesn't work... Show More

    Hi,

     

    I'm trying to display images in a table without having to use extensions. The table object clearly has some related options, but it doesn't work, it just shows the url instead of images. I've read a couple topics regarding this subject and I seem to be doing exactly as pointed, but without sucess.

     

    For instance, this post, shows an example of a cat picture. I've tried adding the URL to the dimension field as he did; as a measure; the url only in the image setting field... none of them worked.

    What am I doing wrong?

    therealdees_0-1727804411130.png

     

     

    PS: I've tried different formats as well, not only SVG as the example above. My objective is to display instagram pictures for which I have a column holding the direct media link, e.g:

    https://scontent-iad3-1.cdninstagram.com/v/t51.2885-15/453891609_519342943850147_566528120705425674_n.jpg?_nc_cat=102&ccb=1-7&_nc_sid=18de74&_nc_ohc=GUiZxLQnZGUQ7kNvgEGPOlY&_nc_ht=scontent-iad3-1.cdninstagram.com&edm=AM6HXa8EAAAA&oh=00_AYAgTUt4G-Nb8Lgw_hWle9FN3kuXiZju-lx2_nWz-unuKw&oe=6701D245

    Show Less
  • forum

    Administering and Monitoring

    Any idea where I can insert javascript to use Mouseflow?

    I need to insert a javascript snippet to see how people are using the UI of our dashboards. I was given a snippet of javascript to insert into my dash... Show More

    I need to insert a javascript snippet to see how people are using the UI of our dashboards. I was given a snippet of javascript to insert into my dashboard.

     

    Is there somewhere I can insert this code? Do I need to create an extension or something to do this?

     

    I tried contacting Mouseflow directly and searching this and I keep hitting walls. Any assistance is appreciated.

    Show Less
  • forum

    App Development

    Questions on Parameterized variables in Qlik

    Hi Team,I am facing a challenge that i am unable to pass string value using $1 variable to another variable.=$(vVariable1($(vVariable2)))vVariable1 = ... Show More

    Hi Team,

    I am facing a challenge that i am unable to pass string value using $1 variable to another variable.

    =$(vVariable1($(vVariable2)))

    vVariable1 = Fractile($1 Aggr(Median($1 Metric),VIN),0.1)

    vVariable2= {1<Set={4}, Dim2=P( ID), Dim1={1}, $3, $4>}

    Here i wanted to pass entire vVariable2 to vVariable1 inplace of $1 , My expressions working fine if i put this set analysis value to the above function but when i am trying to pass this value via parameter . its not getting passed. Please suggest.

    Thanks

    Vish

    Show Less
  • forum

    New! Qlik Answers

    Using API Qlik Answers

    Good afternoonI have tried several ways to use the Qlik Answers API, but I can't get it to work.I appreciate your help
  • forum

    App Development

    Qlik Sense script, is it possible to manually exit script with errors

    Hello,In Qlik Sense, in the load script. If a result of a variable is wrong, i'd like to interrupt the Script.It's easy to interrupt the script : I us... Show More

    Hello,

    In Qlik Sense, in the load script. If a result of a variable is wrong, i'd like to interrupt the Script.

    It's easy to interrupt the script : I use a if then else, and an EXIT SCRIPT; when I need to.

    But is there a way to EXIT SCRIPT as an error ? I mean, when I do an EXIT SCRIPT, the reload stops, but in schedulers the reload appears as a successfull reload. Is there a way to exit script as a failed reload ? 

    (I'm looking equivalent to exit code = 1) 

    Thanks 
    Best Regards  

    Show Less
  • forum

    New! Qlik Answers

    Comandos usados no Qlik Senser

    Estou iniciando no Qlik Senser e gostaria de saber onde consigo apostilas sobre comandos .
  • forum

    App Development

    Lookup between values within script (Qlik on Cloud, not QlikView)

    Given a table such as this[Example]:Load * Inline[LowerBound,Result0,15051,12564,15075,200111,125136,150175,200211,200];Is it possible (without expand... Show More

    Given a table such as this

    [Example]:
    Load * Inline
    [LowerBound,Result
    0,150
    51,125
    64,150
    75,200
    111,125
    136,150
    175,200
    211,200
    ];

    Is it possible (without expanding the table to include every possible value) to do a lookup, such that looking up 70.123 in this table will return 150?  The lookup functions I can find all seem to require an exact match or a string pattern.

    Thanks

    Show Less
  • forum

    Integration, Extension & APIs

    Invalid method parameter in mashup when bullet chart is included

    We are creating a mashup and have included a bullet chart in the mashup.  At some point when clicking around in the mashups an error is thrown Error: ... Show More

    We are creating a mashup and have included a bullet chart in the mashup.  At some point when clicking around in the mashups an error is thrown Error: Invalid method parameters.  The bullet chart seems be causing the problem but can't figure out why.  If I remove that chart from the mashup I no longer see the issue.  I am using the latest, Nov 2024 Qlik Enterprise for Windows.

    Show Less
Leaderboard

Customer Story

Optimizing Food Relief with Qlik

Qlik empowers Foodbank Victoria with real-time data insights, optimizing food acquisition and distribution to deliver 25 million meals annually while reducing waste and costs across its statewide relief efforts.

Customer Story

Data-Driven Strategies Set To Fuel Growth

Qlik accelerates decision-making at Alpha Auto Group, enabling seamless data integration and automation across dealerships, cutting reporting times, and driving scalable business growth.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!