Hi, I have a listbox with dimension "Cod_Tienda", it is possible in Set analysis, to do the inverse sum of everything selected

sum({-(Cod_Tienda)=GetFieldSelections ( Cod_Tienda)}Sales)

this not work

thanks

Hello,

I'm relatively new to qliksense.

I have been dealing with issues of how to make Target Sales and Actual Sales in the same time period dimensions.

So I have about 6 tables.

2 of them are fact tables i  guess:

1. actual sales table (which contains field Year Month as a time period) and the actual sales of each outlet

2. target sales table (which contains also field YearMonth as a time period) and the target sales

Both connects to a calendar table with the field YearMonth as an association.

But qliksense wants me to delete one of the field of YearMonth because it creates a circular reference.

If I delete the YearMonth field in target table, it will cause in the graph I cannot view them side by side because the target table now doesn't have a field YearMonth.

I tried link tables, but it even creates more synthkeys. Is there any solution on this?

Should I join the target and actual sales table and separate both facts with another field named "Version" which contains "sales actual" and "sales target"?

Hi All,

I have one table as below:

ID      Name

1        A

1       B

1        C

2         D

2          E

3          F

3          G

and I want to show 3 different filter panes for Name based on the ID e.g. filter pane 1 will have data as A B C, 2 will have D  E and 3 will have F G. And I want that these filter conditions should not imapct on each other. Hence I am writing below expressions:

Filter 1: =aggr( Only({1< id={1}>}name),name)

Filter 2: =aggr( Only({1< id={2}>}name),name)

Filter 3: =aggr( Only({1< id={3}>}name),name)

which is showing correct output but when I select filter 1 then fillter 2 values are gray out as in the backend data gets filtered out for ID=1 so there are no records for Id 2 and 3 even though I have  written 1 in expression.

Please note we have older versions on server and Alternate states are not yet available there so any way to resolve this issue.

Thanks in Advance!!

Hi All,

I am trying to switch between apps in qlik sense. 

I tried to used the method described in the following link:

https://community.qlik.com/t5/Qlik-DataMarket-Discussions/Switching-between-apps-in-qliksense/m-p/1393159#M3577

However, I am getting an error - The app you specified cannot be found.

How do I fix this?

Regards,

Abhishek

Hi,

If  I use IsNull(getcurrentselections()) in expression and if i select any value in listbox then its taking long time to refresh charts  

Hi,

I am facing a problem to do sum of cumulative sales .Here i attached a .qvw file where in the text view design i want the value 1200 which is the sum of all month cumulative sales.

Thanks in advanced

Please help me out