Hi,

Wanted to check if below features possible in qIik saas and if any reference links or solutions :

1)Writeback to db based on user input in the report table in qliksense application

2)We have an Admin Qliksense appplication where we  have a table with rows as YearMonth and columns as Qliksense application name's and each cell in this table will be a checkbox .If user unchecks a checkbox for a Application and Yearmonth and submit then that application will not show that yearmonths data.

3)Need to maintain a log table for all the changes done in point 2 by User, application,timestamp.

4)We have an input box, if user inputs a value in it, then the table below which has modified date,username,old value and new value column should have a record showing the changes.

5)In the report of few columns and expressions, one of the column acts like a drop down filter for user to select , 

if user selects anything in the dropdown of that column, undo/reset option should be available for the user if he wants to resets the value of the dropdown changes he made

6)Click on a link which automatically creates a readymade email with all contents in email body, to, cc.

7)We have a table of db jobs refresh status in qliksense application, if user selects a job record which has failed and clicks on refresh buttton then that db job starts again .

Hi guys,

How to display label values for certain months in a line chart in Qlik Sense instead of displaying label values for all months. Is there any other way besides vizlib tables, or are there any other free Extensions?

Currently designed with Qlik sense：

final design：

I have data has column names of pick1, pick2, ..., pick5. But I want to make a new list, 'pick' and put these five columns as factors of 'pick', so that I can create a filter pane and get linked. Same as cost1, cost2, cost3, cost4 should belong to a new field,  'cost' , and get linked to the main table.
Now I click the filter panes, but nothing gets selected. 

mainTable:
load*inline [
week,'num of pick, pick1, pick2, pick3, pick4, pick5, cost1, cost2, cost3, cost4, hrSum
1, 3, apple, banana, strawberry, NA, NA, 10, 20, 30, 40, 200
2, 5, durian, grapes, apple, dragonfruit,orange, 20, 25, 0, 20, 300
3, 1, fig, NA, NA, NA, NA, 5, 10, 0, 15, 500
4, 2, lemon, gratefruit,NA, NA, NA, 10, 3, 5, 0, 1000
5, 3, dragonfruit, gratefruit, fig, NA, NA, 10, 20, 5, 4, 200];

colname1:
load * inline [
pick,
pick1,
pick2,
pick3,
pick4,
pick5];


colname2:
load * inline [
cost
cost1
cost2
cost3
cost4];

I searched how to create a line chart with multiple lines based on a secondary dimension but unfortunately, I found several complex solutions (like creating expression using dual) to create a simple multiline chart. Spent several hours to figure out but no luck.

Here is the data looks like:

Order Date on X-Axis

Sales on Y axis for line

Ship Mode: will be on color to show multiple line for each shipping methods.

I thought Qlik was easy, but I felt, it is like Assembly Language for me after using Tableau.

Attached is the screenshot that i am looking to create in Qlik.

Hello support team.

[Info]
Source DB : Db2 for iSeries

[Question]
About following limitation,
>Tables created by DDS: If you need to replicate tables created by DDS, please seek guidance from Qlik Support or your Qlik Customer Success Manager.
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedReplicateHDD/IBM4DB2-iseries/iseries_limitations.htm

Are tables created by DDS enable to be replicated ?
If yes, would you tell me how to replicate these table?

Best Regards.

Hi All,

Stuck at a point where my requirement is show previous 4 quarter based on filter selection in a line chart.

Suppose filter year is selected 2024 and month selected is Mar, which is Q4-2024. This Q4-2024 plus previous 4 quarter to this selection which should be Q3-2024, Q2-2024, Q1-2024 and Q4-2023.

Below is my approach:

Dimension: CalanderQuarter &'-'& Right(fYear,2)

Measure: Sum(
                         {<
                            Date={">=$(=QuarterStart(AddMonths(Max(CalendarDate),-16))))

                            <=$(=Date(Max(CalendarDate))))"},
                                    CalendarWeek=, CalendarDay=, FMonth=, FYear1=, fYear=
                         >} [Amount])