topic Re: Default Data Load in Qliksense in Integration, Extension & APIs

Default Data Load in Qliksense

Fri, 13 May 2016 11:54:58 GMT

Hi . I am loading 2 excel files into Qliksense which have the exact same format but ofcourse different data.

On my dashboard I have a filter pane - Campaign which has 2 options - A (coming from excel 1)& B(coming from excel 2).

I have certain KPI's like reach, email open rate, CTR.

I select either of the 2 campaign A or B and get my metrics. It is working fine

But on opening the dashboard, by default Qliksense is summing up the data from my 2 excels and giving me combined results.

On selecting a particular campaign now, I get the correct data but the default data which is the combination of the 2 excels is not what I want.

Can I select either of the 2 excels as default and get the result from only 1 excel when no selection is made.

Re: Default Data Load in Qliksense

Gysbert_Wassenaar — Fri, 13 May 2016 18:30:24 GMT

Can I select either of the 2 excels as default and get the result from only 1 excel when no selection is made.

No. There's no such thing as a default data load. You'll simply have to make a selection.

Re: Default Data Load in Qliksense

Wed, 18 May 2016 10:22:59 GMT

Making the selection works but when the dashboard is viewed for the very first time it is summing up the results from my 2 excels. These excels contain data from 2 different campaign and summing them makes no sense. how do I control this?

Re: Default Data Load in Qliksense

Vincenzo_Esposito — Wed, 18 May 2016 16:35:25 GMT

If summing them have no sense and you will never sum data all togethe, you can split these data in two different tables and use set analysis to sum up data coming from excel1 or excel2.

The syntax you need is something like this

Sum({<field name={excel1}>}costs)

Re: Default Data Load in Qliksense

Thu, 19 May 2016 11:17:57 GMT

But again will this control the initial load?

I want the data from only excel1 to be displayed when I open the dashboard.

Actually I am creating a master dashboard and the list of my excels will keep on increasing. So on the initial load I just want excel1’s data .