Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deepanshu_chamo1
New Contributor

Qlik Sense Queries

Hello All

I am very new to Qlik sense. I have few doubts. I will be grateful if some one helps me in the below queries

  1. I have “CreatedDate” column in the data set i.e.
    2014-02-04 09:40:00.000000, 2014-02-04 09:50:00.000000, 2014-02-04
    16:40:00.000000 and so on. I used the DATE(CreatedDate) function, which changes
    the date format in to the YYYY-MM-DD but when I used the date as a filter pane
    it shows three fields for 2014-02-04. I want to combine it in to one?
  2. On the same date I wanted to get the dates
    greater than 2014-08-31?
  3. I wanted to use the case statement to make a new
    column which afterward I used as Measure. Where should I use it (load or SQL)
    and how

A = Case When Forward = 0 and FP = ‘ ‘ then 1 else 0 end

B = Case When Forward = 0 and FP = ‘ ‘ then 0 else 1 end

Thanks in advance!!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Qlik Sense Queries

1. Use

Date(Floor(CreatedDate))

to strip of the time part from the underlying numeric value

2. You want to filter in the script or in a chart?

3. Could you post some sample lines of data?

4 Replies
MVP
MVP

Re: Qlik Sense Queries

1. Use

Date(Floor(CreatedDate))

to strip of the time part from the underlying numeric value

2. You want to filter in the script or in a chart?

3. Could you post some sample lines of data?

reddys310
Honored Contributor II

Re: Qlik Sense Queries

Hi Deepanshu,

It would be very easy to solve your issues if you can provide an example.

Thanks,

Sangram Reddy.

deepanshu_chamo1
New Contributor

Re: Qlik Sense Queries

Thanks a lot for the help!!. The  1 query date issue is resolved

I want to filter it in a script, so that it apply to every chart/tables. I used as

where

Date(Floor(CreatedDate)) >= '2014-08-31'

It does not work. Please help me

I have attached the sample examples. I also put the Excel formula which I used in the Excel

I want to create the Column A and Column B in the script.

Please let me know it make sense

Thanks

Deepanshu

deepanshu_chamo1
New Contributor

Re: Qlik Sense Queries

Thanks!!

I have attached the sample examples. I also put the Excel formula which I used in the Excel

I want to create the Column A and Column B in the script.

Please let me know it make sense

Thanks

Deepanshu

Community Browser