Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amberrebma
New Contributor II

show only current month record

in table i have a data like this

    

HeadPrice MonthSub heads
Marketing20012-Jan-17Mark1
Marketing20013-Feb-17Mark2
Marketing20014-Feb-17Mark3
Misc12003-Jan-18Mark4
Misc13001-Jan-18Mark5
Misc130013-Jan-18Mark6
Misc11005-Mar-18Mark7
Ins12005-Mar-18Mark8
Ins13005-Mar-18Mark9
Ins15005-Mar-18Mark10

now here i want to display only current month records and hide all previous old data.. like want to show + button and disable that and want to show current month record

3 Replies
pritamb89
Contributor

Re: show only current month record

load the data to get the month number

LOAD

      Head,

     Price,

     Month,

    Num(Month(Date#(Month,'DD-MMM-YY'))) as MonthNum,

     [Sub heads]

FROM

(biff, embedded labels, table is Sheet1$);

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

Now in a straight table add

dimension: Head,[Sub Heads], Month

Expression : sum({<MonthNum={$(=Max(MonthNum))}>}Price)

Capture1.PNG

amberrebma
New Contributor II

Re: show only current month record

hi ...

i tried this but not working ..

i have records like this

head  price month

abc    234  3/9/2018 

def    112   3/9/2018

dfdf   244  3/9/2018

239   124  2//1/2018

and so on

now i want like this data

head  price month

abc    234  3/9/2018 

def    112   3/9/2018

dfdf   244  3/9/2018

what expression should i use for display all current month records .. i used this

chinnuchinni
Contributor III

Re: show only current month record

abc:

load * Inline [


head,  price, month


abc,    234,  3/9/2018


def,    112,  3/9/2018


dfdf,   244,  3/9/2018


239,   124,  2/1/2018

];


xyz:

load head,price, month,

num(month( Date#(month,'D/M/YYYY')))as Month1 Resident abc ;

DROP Table abc ;




and in Straight table DImensions are: head and Month

                                Expression is : sum({<Month1 = {$(=max(Month1))}>}price)

You will get below o/p :

293565.PNG

Community Browser