topic Re: Dimension in QlikView

Dimension

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

Hi ALl,

In Dimension i have a field called " Depaertment "

now i wat to display the Departments for the Max date of "Date" field ..

How to wright this in Calculated Dimesion ..

Will it be like this ?

max(Date),Department

Please provide siggestions ..

Thanks in Advance

Re: Dimension

Anil_Babu_Samineni — Mon, 16 Oct 2017 08:43:38 GMT

What are you getting when we write like below?

=Date(Max(TOTAL Date))

=Aggr(Date(Max(TOTAL Date)), Department)

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 08:49:03 GMT

Hi Anil sir,

for this below

=Aggr(Date(Max(TOTAL Date)), Department)

Iam getting max of date ...no data

Iam using only Fields in a straight table and there is no expression for this ..

Just wanted to show the detial table..

For all the dimensions i want to show only those recorde which were uodated for max date..

Thanks

Re: Dimension

Anil_Babu_Samineni — Mon, 16 Oct 2017 08:53:58 GMT

Not sure, I understand your concern here. will you able to explain with data set?

Re: Dimension

devarasu07 — Mon, 16 Oct 2017 08:54:13 GMT

Hi,

Method1:

=Aggr(Date(Max( Date)), Dept)

Re: Dimension

its_anandrjs — Mon, 16 Oct 2017 09:10:09 GMT

You can use SET analysis for this

Ex:-

Dim:- Department

Dim:- Date

Count({<Date = {"$(=Max(Date))"}>} Date)

Re: Dimension

imrasyed — Mon, 16 Oct 2017 09:22:04 GMT

Hi John,

Can you try using the below expression in Text object

=Only({$<date={"=max(Date)"}>}Department)

Re: Dimension

PrashantSangle — Mon, 16 Oct 2017 09:28:00 GMT

Adding to Anand solution you can try below

Sum({<Date = {"$(=Max(Date))"}>} 1)

Regards,

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:28:54 GMT

Hi Anil,

OKay

Iam using a straight table which will show the detailed table and it will contain only field names like

Department, Name, City, Sponsoror,and so on. there will not be any expression for this

Now i want to diplay all the details of the fields in chart for max of "Date"..

IJust wanted to how do i achieve this ?

Re: Dimension

antoniotiman — Mon, 16 Oct 2017 09:29:51 GMT

Hi John,

may be like this

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:29:53 GMT

HI Devarasu

Iam using a straight table which will show the detailed table and it will contain only field names like

Department, Name, City, Sponsoror,and so on. there will not be any expression for this

Now i want to diplay all the details of the fields in chart for max of "Date"..

how do i achieve this ?

thank

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:30:48 GMT

Hi Antonio ....

There will not be any expression in my chart.

Its just a table to diplay the detailed information..

Re: Dimension

vikasdesai — Mon, 16 Oct 2017 09:31:30 GMT

Use following Expression

=Aggr(Date(Max( Date)), Dept)

Re: Dimension

Anil_Babu_Samineni — Mon, 16 Oct 2017 09:31:40 GMT

Without expression, I don't like to use Max() function. And for your question go to Properties - Presentation - Suppress the null values. You will get it using my condition where i mentioned earlier

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:40:45 GMT

This is displaying only max date ...

I want to diplay all the list of department for max date

Re: Dimension

antoniotiman — Mon, 16 Oct 2017 09:45:46 GMT

However, can You provide sample Data and Your expected result ?

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:50:25 GMT

HI ANil ,

I used your below suggested Condition and supressed the null values in presentation tab.

But the chart wont display any values...

Aggr(Date(Max(TOTAL Date)), Department)

Re: Dimension

Anil_Babu_Samineni — Mon, 16 Oct 2017 09:53:27 GMT

Try first condition then? But i am sure it should work

Re: Dimension

smilingjohn — Mon, 16 Oct 2017 09:56:46 GMT

=Date(Max(TOTAL Date))

in this there is no Department ?

Re: Dimension

devarasu07 — Mon, 16 Oct 2017 09:58:54 GMT

Hi,

To get your solution correctly & quickly, always try to share with mock data and expected output that would be easy for us to check and help you.

Thanks,deva