Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dmv15956
Contributor

Showing numbers in table with out dates

Hi,

I have a 2 different data set with out any unique id match with each other. 1 does have proper dates and other do not have dates but do have month in text format.

Now I would like to see both info in single straight table.

When I apply 1 set of data in table with its =month(date) and count is shows me 1st set of data, But when I also add 2 set data by it do not give any value. reason it do not have dates to match with 1set of data.

I have attached sample data, hope is make more sense.

I not sure how could I solve it, Please help me.

1 Reply
sumanta12
Contributor II

Re: Showing numbers in table with out dates

Hi Dipesh,

Script:

TAB1:

LOAD

'AUDIT' AS ORIGIN,

Status,

MONTH(Date) AS MONTH,

     [Audit Level],

     Location

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1)

WHERE ROWNO()<7;

CONCATENATE

LOAD

'LEARNING' AS ORIGIN,

Status1 AS Status,

     Learning,

     Location1 AS Location,

     MONTH(DATE(DATE#(Month,'MMM'),'MMM')) AS MONTH

FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1)

WHERE ROWNO()<15;

-----------------------------------------------------------------------------------------------------------------------

pic.PNG