topic Re: Pls Help in QlikView

Pls Help

antonybi — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Am trying to get below output with my actual data.

I have some sample data(Main/NoShow) in two sheets and looking for below desired output.

I have tried with apply map and lookup but not getting what exactly looking for.

Any suggestions will be appreciated.

Kindly help!!!

Anil_Babu_Samineni — Sun, 15 Oct 2017 17:18:55 GMT

May be attached?

Anil_Babu_Samineni — Sun, 15 Oct 2017 17:20:16 GMT

To get correct format use this?

Date(MonYr,'MMM-YY') as MonYr,

antonybi — Sun, 15 Oct 2017 17:32:59 GMT

Hey Anil thanks for your quick suggestion.

am unable to open your attached as am using only personal edition.

Can you paste your script here??

Also find attached sample one and correct If am anything wrong.

its_anandrjs — Sun, 15 Oct 2017 18:28:50 GMT

You have to load this way

Script:-

LOAD Date(MonYr,'MMM-YY') AS MonYr,

Emp,

Dept,'EmpNonshow' as TabFlag

FROM

NoShow.xlsx

(ooxml, embedded labels, table is Main);

Concatenate

LOAD Date(MonYr,'MMM-YY') AS MonYr,

Emp,

process,'Noshow' as TabFlag

FROM

NoShow.xlsx

(ooxml, embedded labels, table is NoShow);

Chart Expression:-

Dim:- MonYr

Expre TOTAL HC:- =Count ( {<TabFlag={'EmpNonshow'}>} Emp)

Expre Noshow Emp :- =Count ( {<TabFlag={'Noshow'}>} Emp)

Expre Non Noshow Emp :- =Column(1)-Column(2)