topic Re: How to create a dashboard ? in QlikView

How to create a dashboard ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys, I have a list many companies. I have their income statement. I need to create a dashboard where when I click on a certain company, I would ideally want to see a graph of the income in the current and past term. I have the current and past term values in 2 different tables. Right now I have loaded the info on only one company and when I create everything, I would add the other excel sheets with the other companies data.

Re: How to create a dashboard ?

Kushal_Chawda — Thu, 10 Mar 2016 11:16:28 GMT

what is the show stopper for you?

Re: How to create a dashboard ?

Thu, 10 Mar 2016 11:18:11 GMT

Ok. I know how to create the dashboard as in a chart or whatever but I don't know how to incorporate the "profit" tables into the dashboard chart. I guess line chart would be the best. I tried a few things with adding it into "expression" tab but with no luck.

Re: How to create a dashboard ?

kushalthakral — Thu, 10 Mar 2016 11:22:27 GMT

Hi Dilyan

You can have Month, Year and Quarters as time filters which you can derive from date easily.

In your graph you can show the trend means this year vs last year etc and also show the Table for the same and show Percentage distribution in Pie charts.

Regards

Kushal Thakral

Re: How to create a dashboard ?

Thu, 10 Mar 2016 11:24:05 GMT

I get that..but how do I incorporate the data from "this term" and "last term" into the dashboard. That's essentially my question... Also I need to create some financial rations. Do I create them in a text box ?

Re: How to create a dashboard ?

kushalthakral — Thu, 10 Mar 2016 11:30:30 GMT

You can write two expressions like

Sum({<year ={$(=max(year))}>}Sales) For current Year

Sum({<year={$(=max(Year)-1)}>}Sales) For Previous year

Like that you can create expressions and used in line chart for trend.

Re: How to create a dashboard ?

ramasaisaksoft — Thu, 10 Mar 2016 11:36:46 GMT

Hi Dilyan,

i think in Expression you need to give AND condition for both years and company name

if(company ='x' and year=2016,sum(sales),

if(company ='Y' and year=2016,sum(sales))).....etc

Re: How to create a dashboard ?

engishfaque — Thu, 10 Mar 2016 11:43:31 GMT

Dear Dilyan,

I would recommended to you please share your sample App, Data and Questions. As the appropriate answer/solution can be given to you.

Kind regards,

Ishfaque Ahmed

Re: How to create a dashboard ?

Thu, 10 Mar 2016 11:44:33 GMT

Data is not in English,so it would be hard for you to understand it..