Hello

I have a table of questions and answers from an account.
Some questions are multi choice and I would like to have a line for each of them.

For example:
QUESTION ID, ANSWER
1, Yes
2, No
3, 1^5^10

For question 3, it is a multi-choice question where the user has selected 3 answers.

I would like to obtain the following final table:

QUESTION ID, ANSWER
1, Yes
2, No
3, 1
3, 5
3, 10

How could I get it?

Hi,

I want to be able to find duplicated records within a table with around 100 fields.

I have a table with over 100 fields and i have a script that finds duplicated ID's but I want to know which field is responsible for the duplication.

Here is an example the ID is the same so as the cost but the number is different.

Any help ill be great.

Hello,

I want my users to be able to add a favorite that selects all the elements in a column > 90. But when I try this, and select 'select all the possible values', it selects all the values of the column without taking in consideration the >90.

Hello,

I have used filter panes in one of my sheet in qliksense. One of the filters is to select Gender. The filed name in my data source is Gender and it has rows for F (as female) and M( as male). Previously, I had this expression behind my filter 
if(Gender='F','Female',if(Gender='M','Male')). it works fine.

Now user wants that every time they open the sheet it filters out the report automatically or by default to Male. and later, if they need then change and select the Female option in the filter.

I have set this variable in the main section in data load editor SET vDefaultFilter='Male', and modify the expression like this: if(Gender='F','Female','$(vDefaultFilter)')

the expression says ok but it does not filter data by default to Male. I still need to go and select Male option.

could someone help please?

Thank you!

I'm working on converting some reports from QlikView over to SSRS.

I'm looking for this calculation in particular (screenshot). I know that REMAINING_HOURS is not an actual column in the OPERATION table in the database and that there's a calculation being done to get REMAINING_HOURS.  I can't find how it's being calculated though.

When I go to Edit Scripts... and look at the Operation tab, I don't see anything referencing REMAINING_HOURS.

I'll also say that Production Schedule is a report within this .qvw and that I'm also not a frequent or seasoned user of QlikView.

Could anyone point me towards where I can view how this field is being calculated?

I am new to administration for Qliksense. I published an app from Dev (QMC2) into Prod (QMC) which overwrote it. That was the wrong app so I am being told to revert back to the previous version of the app. How can I do that? Is it possible?

Hi, I am new to qlik,
I have a pivot table with the dimensions group and subgroup.
the group field is a concatenation of group number and the group name (Num_Group & '- '& Group) and the Subgroup field has the same logic
( (Num_Subgroup & '- '& Subgroup)).
The problem is that I get a null concatenation in the filter panel.
in my dimension I was putting this expression: if(isnull(Group_concat or Group_concat='-'), Group_concat), but it still doesn't remove the null concatenation from the filter...
Can you help me, please.

Hi !

I'm having a couple of issues with my Qlik setup and would greatly appreciate some guidance.

Firstly, my scheduled tasks are failing, and the QMC is displaying the message: "The sequence of events was not completed. Check engine or script logs." In an attempt to resolve this, I've cleared out all logs within the archive logs folder, leaving only three months of history. Additionally, the disk space on the service cluster appears to be sufficient.

Also, for my first daily task that trigger the rest I see that it executed successfully when I see the reload script log but the task status is failed so it doesn't trigger the other tasks.

Secondly, when I try to duplicate apps from QMC, I receive the following error message: "Failed to load Properties. No data found."

Does anyone experienced this before and know what is the cause for this?

Can a background color be set for cells in a trellis container using colormix2?  The charts are histograms and I would like to show deviation from the mean as one of two colors, with white being close to or at the mean.

If it can be done, I would assume it would be in the Master Visualization under Presentation, Styling / General / Background Color / By Expression, but not sure of the correct expression.  For regular tables it's something like:

=colormix2(
(rank(TOTAL column(1))/(NoOfColumns(TOTAL)/2))-1,
rgb(20,20,20),
rgb(100,100,100),
rgb(200,200,200)
)

But this does not work for Trellis Containers.