Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
jerryyang756
Creator
Creator

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

Anonymous
Not applicable
Author

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
Creator III
Creator III

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