Qlik expressions are defined in the Expression Editor.
Questions tagged [qlik-expression]
96 questions
0
votes
1 answer
Qlikview ignore selection in text box (object)
I have a text box that contains an expression, however i dont want it to be affected by the selections in the list boxes.
=SUM(IF( (date(Monthname(C_DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
Matt
- 14,906
- 27
- 99
- 149
0
votes
1 answer
Qlikview Count of ids in last 12 months in text object (box)
I have two fields in my table Date & ID, i want to put in a text box the count of all the ids for the last 12 months.
This returns nothing:
=Num(count({$=$(=AddMonths(Today(),-12))'}>}[ID]),'#,##0')
This returns the correct…
Matt
- 14,906
- 27
- 99
- 149
-1
votes
1 answer
Auto-increment/identity column in Snowflake table loaded by Qlik Replicate
I am loading data from a flat file (csv) into a Snowflake table using Qlik Replicate tool. In the Snowflake table, I have a column called "load_rec_num" to store something like ROWNUM of Oracle, that is, an auto incrementing numeric value as data is…
Jay
- 47
- 11
-1
votes
1 answer
Cumulative sum with condition
I wish to derive cumulative column based on initially adding the daily amount to the Value, then subsequently adding the daily amount to the resulting figure.
Could you please help,…
LoKi_Asterix
- 7
- 3
-1
votes
1 answer
What are the ways to publish apps/sheets from Qliksense?
I have Sales database which contains sales data along with manager IDs, I have created the required reports in Qliksense and want to use Qliksense reports on custom UI (on an app).Also want to apply row level security so that one manager would be…
Sneha
- 1
-1
votes
1 answer
QlikView Expression that ignores some selections and contains where explicit values
I have a basic expression SUM(value).
I want to modify this expression so it does 2 things:
Ignores all list box selections except one (yearperiod) and contains explicit where conditions.
Pseudo expected expression:
(SUM(value) Where category =…
Matt
- 14,906
- 27
- 99
- 149