Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
So I have a small problem showing some data on qlikview.
I have a example attached.
On this example you can see a table box with some results that come from an excel sheet.
On the first two rows all the values are the same except for the values of column_7.
What I would like to know is how can I show only one of these lines (the first two), preferably the one with the smaller date.
Can anyone help?
Thank you in advance!
Best regards!
P.S. I have a personal version of qlikview so if anyone changes something and sends to me with the pro version of qlikview I wont be able to open the document.
Ivo Marques wrote:
...
What I would like to know is how can I show only one of these lines (the first two), preferably the one with the smaller date.
Assumg, you meant smaller column_7 value.
Take a straight table:
dimensions: all six coulmns
expression: Min(column_7)
Ivo Marques wrote:
...
What I would like to know is how can I show only one of these lines (the first two), preferably the one with the smaller date.
Assumg, you meant smaller column_7 value.
Take a straight table:
dimensions: all six coulmns
expression: Min(column_7)
I think you can use a straight table instead of table box.
select the 6 columns as dimensions and as exrpession set "min(Column_7)".
Result:
Hi,
Create new chart --> Straight table
Dimensions
Column_1
Column_2
Column_3
Column_4
Column_5
Column_6
Expression
=min(Column_7)
Regards
ASHFAQ
Hello gentleman,
The solution provided worked.
Thank you for the help!
Regards