Hi Everybody,

I need to build a historic table by An QlikView Script 🤔.

My script begin like this :

And the results :

But i want to have a result like this with the value 0 that replace the character  "-" : 

I've tried this     without success 🙄

The script show me a issue "Invalid Expression" 🤕

Can you help me ?

Thanks,

Fanch

Hi All, 

I have a inline table "Category"   which I am considering as a filter pane. 

If I select Category (Cosmatic) then i want to hide my 3 columns (football,cricket and movie) and show only one column BeautyProduct in my pivot table . 

and when i dont select Category then BeautyProduct should be hidden and  3 column  (football,cricket and movie) should be displayed. 

How can I cahive this ?

Thanks in Advance

Hello Everyone, I connected qliksense cloud business with qliksense .net sdk or enigma. I'm using API key to connect. I can access objects and object hypercube but can't export data. Because engine return "access denied" error.Anyone have any idea?  

 I have a Stacked Bar Chart which i need in %.

I have two Dimensions and one measure.

The expression im using is below:

Count({<Year = {"$(=Max(Year(TODAY())-1))"}, Transaction_Type={'New Booking'},[Service Type]={'Air'},[Dom / INT'L]={'Domestic'}, [Trip anticipation]-={'Undefined','Back Dated'}>} [# of Transactions])

I want a 100% Stacked Bar chart. please let me know if there is a possibility.

we just migrated our apps in micro soft azure and when we are trying to reload the apps we are getting below issue in our app, looking like some memory allocation issue, can any one guide us on how to avoid this error..

Few more inputs : Local server Qv 11 and Azure version is Qv 12.

Please look into the below image.

Thanks Much in advance.

Hey,

I'm being interviewed for a business analytics manager position, I'm very familiar with power bi, but their bi platform is built on qlik which I've never used and quite frankly only heard isn't as easy at all as power bi is.

question is, is qlik superior to power bi in some way, just wondering if there is a chance I could convince them to migrate to power bi.

and no, don't really need opinions on whether I'm suitable for the position given my lack of experience with qlik, I'll leave it up to them to decide

Can anyone please explain the meaning of this condition?

[Base Year] = max({1} [Base Year])

If I select 2021 as Base Year, what will be the output?

@marcus_sommer 

Hi All,

    I have a pivot table, ticked 'Show All Values' and unticked 'Suppress Zero-Values'  in all dimensions and tried both the expressions below to display all values even if it is null. Both the expression works but when selecting a record to view, system makes zero for all other records and shows all data. Is there anyway to hide all other records and display only selected records in pivot table? 

Expression 1

=if(sum({1} [# Total Hours]) <> sum([# Total Hours]), sum([# Total Hours]),0)

Expression 2 

=sum([# Total Hours]) + Sum({1}0)

Thank you.