Welcome to Qlik Community

Hi there, I've got an issue that is affecting one user only that i'm really struggling to rectify/fix. 

Whenever the user logs into the Qlikview dashboard they automatically have a filter applied to a field, and are unable to clear the selection. This is stopping them from using the dashboard any further at the moment. The filter is 'stuck' on a few selections within that field, but not all available options in the field.

I have tried revoking their licence and re-setting them back up, but to no avail. There is nothing in the scripts that should restrict any data to this specific user, and we have over 50 accessing the same dashboard with no issues what so ever.

Has anyone got any ideas on what else i could try? Happy to provide more detail!

Set analysis:

=Codigo & ' ' & concat(aggr(' - '&' FL: ' & Filial & ' ET: ' & NUM(sum(Estoque),'000000')& ' RK: ' &NUM(rank(sum(Estoque)),'00'), Codigo, Filial),'',aggr(rank(sum(Estoque)),Codigo,Filial))

If the Rank branch has zero stock. stay in red

Codigo   Rank
100 100 - FL: 2 ET: 000099 RK: 01 - FL: 3 ET: 000088 RK: 02 - FL: 1 ET: 000000 RK: 03
101 101 - FL: 2 ET: 000151 RK: 01 - FL: 1 ET: 000150 RK: 02 - FL: 3 ET: 000044 RK: 03
102 102 - FL: 3 ET: 000560 RK: 01 - FL: 1 ET: 000380 RK: 02 - FL: 2 ET: 000341 RK: 03

I have  a area chart in Qlik sense  It showing line for even I got zero as a value. But ,When try to see the same chart in  Nprinting report It wont show the line.

Find the below images

Why the line is not showing in the report

@Daniele_Purrone  Qlik NPrinting   Qlik Sense   Qlik Data Catalyst  , Lech_Miszkiewicz

Is it possible to have more than 5 dimensions in Sankey chart (part of the Visualization Bundle)?

I remember that in the extension that was published on Qlik Branch there was a possibility to extend the last added dimension somehow. Is this possible in this official one? Because the last release from GitHub does not work on new Qlik Sense versions.

Hi guys,
I want to convert the SQL query I mentioned below into a format that qlik sense can understand. Can you help me with this?

Thanks ALL

"

SELECT
ODS.ddd_ARC_TABLE1_EXTERNAL_ID3,
ODS.ddd_ARC_TABLE1_EXTERNAL_ID5,
ODS.ddd_ARC_TABLE1_NAME,
ODS.ddd_ARC_TABLE2BATCH_ID,
CUSTCALL.MAX_CALL_DATE,
CUSTCALL.MIN_CALL_DATE,
ODS.ddd_ARC_TABLE2LIST_ID,
COUNT(ODS.ddd_ARC_TABLE2CUST_KEY),
TRUNC(ODS.ddd_ARC_BATCH_MASTER.IMPORT_START_DATE),
COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN PREDIAL2.RESULT IN ('FLAG 1 NO','FLAG 2 NO','IP VAR,KVKK YOK') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (12) THEN ODS.ddd_ARC_TABLE2CUST_KEY END) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 0 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) AND ODS.ddd_ARC_TABLE2RES_REACHED = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
CASE WHEN COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) = 0 THEN 0
ELSE CAST(COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE NOT IN (1,8,9) AND ODS.ddd_ARC_TABLE2RES_REACHED = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END) AS FLOAT)
/ CAST(COUNT(ODS.ddd_ARC_TABLE2CUST_KEY) - COUNT(CASE WHEN PREDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') THEN ODS.ddd_ARC_TABLE2CUST_KEY END) AS FLOAT) * 100
END ,
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_IS_SUCCESSFUL = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (7) THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (9) AND ODS.ddd_ARC_TABLE2LAST_AGENT_ID = 'DIALER' THEN ODS.ddd_ARC_TABLE2CUST_KEY END) ,
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (8,9) AND ODS.ddd_ARC_TABLE2LAST_AGENT_ID <> 'DIALER' THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_CTI_ID IN (11,12) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (3) THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 1 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 2 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 3 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RECORD_STATE IN (1,8,9) AND ODS.ddd_ARC_TABLE2CALL_COUNT = 4 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2CALL_COUNT = 5 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2CALL_COUNT > 5 THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
COUNT(CASE WHEN ODS.ddd_ARC_TABLE2RES_EXPLANATION = 'CANCEL' THEN ODS.ddd_ARC_TABLE2CUST_KEY END),
TO_DATE(ODS.ddd_ARC_TABLE2EXPIRE_DATE)-TRUNC(CURRENT_DATE),
NVL(BATCH_DETAILS2.IMPORT_EDILEMEYEN,0)
FROM
ODS.ddd_ARC_BATCH_MASTER RIGHT OUTER JOIN ODS.ddd_ARC_CDS ON (ODS.ddd_ARC_TABLE2BATCH_ID=ODS.ddd_ARC_BATCH_MASTER.BATCH_ID)
LEFT OUTER JOIN (
SELECT
ODS.ddd_ARC_LOGDIAL.CUST_KEY ,
ODS.ddd_ARC_LOGDIAL.RESULT
FROM
ODS.ddd_ARC_LOGDIAL
WHERE
ODS.ddd_ARC_LOGDIAL.RESULT <> 'Allowed'
AND
ODS.ddd_ARC_LOGDIAL.ID IN (SELECT MAX(ODS.ddd_ARC_LOGDIAL.ID) FROM ODS.ddd_ARC_LOGDIAL WHERE ODS.ddd_ARC_LOGDIAL.RESULT <> 'Allowed' GROUP BY CUST_KEY)

) PREDIAL ON (PREDIAL.CUST_KEY=ODS.ddd_ARC_TABLE2CUST_KEY)
LEFT OUTER JOIN (
SELECT
ODS.ddd_ARC_CUSTCALL.BATCH_ID,
MIN( ODS.ddd_ARC_CUSTCALL.CALL_DATE) AS MIN_CALL_DATE,
MAX(ODS.ddd_ARC_CUSTCALL.CALL_DATE) AS MAX_CALL_DATE
FROM ODS.ddd_ARC_CUSTCALL
GROUP BY ODS.ddd_ARC_CUSTCALL.BATCH_ID
) CUSTCALL ON (CUSTCALL.BATCH_ID=ODS.ddd_ARC_TABLE2BATCH_ID)
LEFT OUTER JOIN (
SELECT
ODS.ddd_ARC_LOGDIAL.CUST_KEY,
ODS.ddd_ARC_LOGDIAL.RESULT
FROM ODS.ddd_ARC_LOGDIAL
WHERE ODS.ddd_ARC_LOGDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO')
AND ID IN (SELECT MAX(ODS.ddd_ARC_LOGDIAL.ID) FROM ODS.ddd_ARC_LOGDIAL
WHERE ODS.ddd_ARC_LOGDIAL.RESULT IN ('FLAG 1 NO','FLAG 2 NO') GROUP BY ODS.ddd_ARC_LOGDIAL.CUST_KEY)
) PREDIAL2 ON (PREDIAL2.CUST_KEY=ODS.ddd_ARC_TABLE2CUST_KEY)
LEFT OUTER JOIN (
SELECT BATCH_ID, COUNT(*) AS IMPORT_EDILEMEYEN
FROM ODS.ddd_ARC_BATCH_DETAILS
WHERE STATUS = 2
GROUP BY BATCH_ID
) BATCH_DETAILS2 ON (BATCH_DETAILS2.BATCH_ID=ODS.ddd_ARC_TABLE2BATCH_ID)
WHERE
ODS.ddd_ARC_TABLE2ENABLED IN ( 1 )
GROUP BY
ODS.ddd_ARC_TABLE1_EXTERNAL_ID3,
ODS.ddd_ARC_TABLE1_EXTERNAL_ID5,
ODS.ddd_ARC_TABLE1_NAME,
ODS.ddd_ARC_TABLE2BATCH_ID,
CUSTCALL.MAX_CALL_DATE,
CUSTCALL.MIN_CALL_DATE,
ODS.ddd_ARC_TABLE2LIST_ID,
TRUNC(ODS.ddd_ARC_BATCH_MASTER.IMPORT_START_DATE),
TO_DATE(ODS.ddd_ARC_TABLE2EXPIRE_DATE)-TRUNC(CURRENT_DATE),
NVL(BATCH_DETAILS2.IMPORT_EDILEMEYEN,0)   "

Hi,

I start from this kind of Input Date

NDC,Data,Class
1,2020/01/01,A
1,2020/02/01,B
2,2020/01/01,A
2,2020/02/01,A
3,2020/01/01,C
3,2020/02/01,A
4,2020/01/01,B
4,2020/02/01,B
];

I would like  to count the number of Class Changing of my Customer and show the results in a matrix like this.

I could calculate the previous Class in the Load Script, using previous function, but I would like to be able to do it in the presentation, may be using additional dimension (e.g Class_Prev, Class_Cur).

Could you help me ?

Michele

Hi guys,

I have a fully functional web dashboard used by clients with multiple qvws available. I am trying to add a new qvw but I can't find out how to link the qvw to a stored image that would act as the icon for the clients to click on via the access point page. I was able to duplicate an existing qvw and add that but I need to change the thumbnail.

Can someone point me to the exact place where this connection between qvw and dashboard image happens? It's probably something really simple. I am using Qlikview 12.10.

Hello,

I have a view on the table in the database that contains all orderlines to be picked in the warehouse.

A person starts an order that containers multiple lines for 1 customer.

Those lines are then processed in order of closest location in the warehouse.

When the person starts a line on his barcodescanner a "start-timestamp" is written into the table.

now i  calculate in excel the time between the timestamp on 1 row and the time stamp on the row before, but only if the previous row has the same id_picking  and the it is being treated on is the same day.

If the Id-picking or the date of the picking is not the same as the  previous row i add a standard time of 2 minutes, assuming that's the time it takes to start a new order or restart the same order but on the next working day.

In excel this is rather simple, i first order all the data on the date of the picking, picking Id and then the timestamp. that way i am sure that if i compare to the previous row it is correct.

But if i import this view into qlikview then i'm stuck on how to do this.

Anybody who might have an idea on how to do this?

i attached a subset of the data.

thanx a lot!

Chris

Hi Everyone.

I nee one help.. I calculate a Difference Between Current Year Sale and Last Year

like..

num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},[CALYEAR]={">=$(vCurrentYear)"}>}[_volume_SO]),'##.0')-  num(Sum({$<[HSUBSEGM.descr]={"Clinker and Cement"},[CALYEAR]={">=$(vPreviousYear)<=$(vPreviousYear)"}>}[_volume_SO]),'##.0')

so I m getting and answer Suppose.. This Year sale is 100 Rs and Last Year sale was 50 Rs.. so total growth 50 Rs.. But I want to show growth in %.. in this case my Revenue growth is 50 %.. because it got double from last year..

Please help me how to do this