Hi there,

For the below table, I would like to add the where clause on the below condition to table attached below;

My condition for where clause to extract the table is:

1st Condition: Product = 'Mobile' and Market = 'Openmarket

2 nd Condition: Product =  'TV', 'Fan'  and Market = 'Closedmarket'.

Table Name: Retail

Hi everyone,

Hope this question was not posted here before - at least I couldn't find anything related. 

So the problem is that we have a web app build with QlikView, where we have couple of tables with photos. After we change the load method from BUNDLE to INFO, they stopped showing up. What is weird is that it works perfectly fine in sandbox environment and both environments are said to have the same settings.  What is also weird is that images that are put in text fields work just fine, so the problem seems to be only with tables. That's also not hardware related as server has more than 32GB of RAM.

I will appreciate any help with this 🙂 Thanks

Hello all, 

I have an issues when I Try reloading data in the QMC, the task fails every time but I reload the same app in the HUB it reloads without any issues.  The Data is been pulled from excel files that are dropped in a drop zone.

Any help with this would be very helpful. 

Hi,

I have a cell format in H:MM:SS - This means the excel is displaying for example:

0 hours, 21 mins, 38 secs = 0:21:38 (This is how the excel cell looks like)

I  just want it to display as per the format in excel which is like this. However,  when i load this data and try to display it in qlikview, it shows: 0.0147916666666667

May i know how to display my cell as per how its meant to be? Note: i do not want it to display HH:MM:SS (because i will not have 10 hours. I simply want it as per what it is: H:MM:SS. i do not need to average it or anything, so i just want to display the value only.

Hoping to seek some help

Hi all,

I have a field in my database called date with 2 values: 31-12-2021 and 01-01-2022.

So i created a filter using date field and i could see both values. The thing is that at the first time there is no option selected, i would like to have the max date by default selected in the filter.

Is this posible?

Thanks

Hi Qlik Support,

                               One of our clients is continuously encountering the 'You can not access Qlik sense you have no access pass' error for all the users.

I tried to solve the problem by taking help of solutions provided on Qlik Community forum, but none of them worked so far.

I need urgent help of Qlik Support team to resolve this issue.

Client Name:- Hitachi Payment Services Pvt Ltd

License Product Name :- QSE Client-Managed for QSE SaaS - Test
License Key (Test):- 1231525336128587

Advance Thanks

Hi, 

I have a pivot table looks like this: 

So I would like to calculate Average Amt Per Product Per Month. Currently I use this but it didn't work (return 0)

SUM(Amount)/COUNT({1<[Month] = {"$TOP([Month])"}>}DISTINCT total [Product] & '|' & [Month])

I also tried to see if TOP([Month]) returns correct value and yes, it matches its corresponding month for each of the row there, but when I include it to the whole calculation then it doesn't work. 

Basically my idea is to have the count calculation ignoring the Product field and getting dynamic with the Month field. 

Please advise.

Thank you so much