Welcome to Qlik Community

Hi Guys,

We have a requirement to stop logging queries of one particular application mostly because of the PII security concerns over the parameters of the query? 

Can we disable log just for this particular application? Or could we encrypt the logs for this particular app?

Please advise.

Thanks in advance.

Regards,

Ritesh Pathak

Hi Team,

I have a table like below which has date campaign clicks and hour.

Every hour when data gets pulled from DB, its a cumulative hourly pull

Eg:  when data is fetched at 3am, it fetches from 12am -3am  & when data is fetched at 4am, it fetches from 12am -4am

So my requirement is to get a hourly breakdown for the clicks for each hour as shown in Output

How to achieve this in back end script?

@Kush @sunny_talwar @Taoufiq_Zarra 

Hello,

I have noticed that the Qlik Sense Dev-Hub does not open in IE on a new install with HTTPS but does on Chrome. 

What I get are the circles.

Does anyone have a solution?

Thank You,

Michael

Here is the issue I am having. I have a table chart with a count and cumulative count(using the Full Accumulation radio button on the Expressions Tab). 

When I have nothing filtered the values are as expected.  But as I start filtering the cumulative Count adjusts to the filter by excluding values outside the filter context. 

In the two screenshots posted. I want the #CumCount values shown in the screenshot without filters also to show up in  the case where filters are selected.

The #CumCount for Jun 2020 should be 19,035 instead of 3,000 all the time.

I want to calculate the cumulative count ignoring some or all of the filter contexts.  Is there an expression for that?

With out Filters

With Filters

Thanks

I have an Excel report that uses a cycle, and has levels and paging, and the destinations include one network folder, 2 individual email addresses (one of which is myself), and an NP Group that has 3 users/emails.  I have noticed that if I run this just for myself and the folder destinations, it runs in about 30 mins, however when all destinations are included (5 user emails and 1 folder) it runs well over 3 hours (I actually killed the task 3.5 hrs in; it was 83% done).  I know cycles, levels and paging add a lot of performance overhead, but what else is happening to make this run so long?  Does NP generate one report and then distribute it or is it going through the process of re-generating a report for each destination?  Does it not like an NP Group as a destination?  Looking for any insight.  Thanks.

Hi Experts,

Please find the attached excel file, where i need to get color as per the value present in cell.

Ex: If the cell value is DGR the cell color should reflect as "Green color" in Qliksense.

I did crosstable for all the months (1,2,3...12) and values(DGR,LGR..) as Data

like Crosstable(Month,Data,7)

So coloring the cell in qliksense i used the below expression. but its showing error.

If(Data="DGR",Green())  I even tried If(Data="DGR",RGB(102,204,0)) but no luck

Kindly help me with the Expression please

Thank You 🙂