Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satishqlik
Contributor

need help with linechart

Hi everyone,

I have a requirement on line chart in Qlikview/Qliksense, Please find the below attachment

>by defalut it has to show Sum(Vol)....(if no selections made)

>If I select any brand it has to show 2lines

one line with Sum(act) and another line with Sum(fore)

I have created two saparate line charts with Sum(Vol) and another line chart with Valuelist.

But I want to show both requirements in single line chart(to put both expressions in single line chart) based on these conditions.

I have tried with Getselections but not working.

Dim1: Year

Dim2: If(GetSelectedCount(Brand)=0,brand,ValueList('_Act', '_Fore'))

If(GetSelectedCount(Brand)=0, Sum(Vol), Pick(Match(ValueList('_Act', '_Fore'), '_Act','_Fore'), Sum(act),Sum(fore)) .

Any suggestions will be appreciated.

Please help me out in this.

Tags (1)
5 Replies
MVP
MVP

Re: need help

Please provide a descriptive text for the title of your question. Community guidelines will explain why.

sasiparupudi1
Honored Contributor III

Re: need help

What is not working properly?

how are act and fore related to brand?

Employee
Employee

Re: need help with linechart

My interpretation of your requirement is that you are looking for two different views on your data. One view shows the volume, and the other shows actual vs forecast sales. What I don't understand is why you would want to force theses two things in to the same chart? I think you are over complicating this, my advise keep things simple and manageable.

My main suggestion is that you think of the workflow you want to create in the Qlik Sense app. Essentially, don't force the business user into a guided reporting model, where you dictate what the user should look at. Allow more flexibility around the discovery of your data.

There are two very simple options, which might work in this case. 

  1. Create two chart in the same sheet. One shows volume, and one shows sales. This allows your user two look at both things at the same time. If you struggle with fitting the charts into the same sheet, take a look at April 2018 release and the new option to resize layout grid.
  2. Create different sheets. User can navigate to for example a sales sheet and look at more details related to actual vs forecast sales. By leading the app with a overview dashboard, and providing more details through additional sheets you give the user flexibility to navigate the data in many ways.

Regarding your attempted solution. My general advise is that you avoid using calculated dimensions, as this will easily lead you to unexpected results, or in worst case misleading results. Commonly when you want a selective filtering the expression can have set expressions or if statements to control the aggregated data set.

If you are not familiar with synthetic dimensions, I would advise on not using Valuelist() in you charts. This function will not provide you the pairing of values that you expect.

satishqlik
Contributor

Re: need help with linechart

Can you provide sample solution and I have attached sample data in the above.

I achieved the same thing in Qlikview but I want in Qliksense.

please help on this.

Employee
Employee

Re: need help with linechart

You are referring to two charts. Both have very simple measures, I am not sure why you can not set it up yourself.

You example has a synthetic complexity that does n t make any sense at all to me. Dimensions and measures essentially work the same way in QlikView and Qlik Sense, so if you have something that works in QlikView just apply the same in Qlik Sense?

Community Browser